Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
Jayakumar

### Calculated measures, calculated cells, and custom rollups issue

Hi,  I'm a little bit confused according to the purpose of Calculated measures, calculated cells, and custom rollups as they lead practically to the same goal, is there any differnce between those modes from a technical point of view. And for the last one, the custom roll up the question how to perform this, I need a walkthrough that lead me to undersand the way to set a custom roll up to a given dimesion, I visited microsoft site but the inforamtion that I have is poor, so is there any other source that exposes that as a step by step example? Thank youThe complexity resides in the simplicity

### Replace pre-calculated Measures at "All" Level depending upon the Dimension Hierarchy Level

Have an interesting Challenge; thought will reach out to you if you can help Currently I am working on SSAS 2008 OLAP Cube, whereby most aggregate level measures are pre-calculated using the C# Code as part of ETL and are stored in Data Warehouse as well as Measure Groups in Cube (MOLAP). These are mostly non-additive measures have to choose this approach for performance reasons, considering the complexity of the aggregations and data volumes.  Data  Volumes are Huge (about 300+ Million Rows/ per day),  98 % of measures are non additive / semi additive.  Cube is used primarily for advance analytics and will be eventually used for data mining like time series , what if analysis and scenario analysis  Excel is used as front end . Question is how can we replace the aggregate level data for various dimensions attributes (Totals and Grand Totals) from pre-calculated measures, those are also available in the Cube as measure groups? We are currently using Scope and Root statement which is not working as expected SCOPE ([D1].[H1].[A1], M1) Root (D1) = <Get Pre-calculated value for M1 from related Measure Group for D1].[H1].[A1],  > EndScope; SCOPE ([D1].[H1].[A2], M1) Root (D1) = <Get Pre-calculated value for M1 from related Measure Group for D1].[H1].[A2] > EndScope;   Thanks in Advance   Best Regards,   Dave

### Help with Calculated Measures

Hi All,

I need to calculate adjusted Revenue based on Total Revenue - Tax - COGS.

But my Tax/COGS are based on Product Types, Partners, etc...

e.g.

Tax       COGS

Partner 1     10%      5%

Partner 2      5%       10%

Partner 3      5%       0%

............

My questions are as follow:

1. Is this kind of calculation best done in MDX or TSQL?

I have about 280K rows per month, and 28 calculations per row (e.g. c= a x b is 1 calculation, then d = c * 0.1 is another), so about 8 Million calculations.  It's done using Excel 2010 currently.

2. How do I deal with zero or empty cell, will MDX speed up the performance?

3. How do I do this kind of calculation in MDX?  I don't know how to setup dimensions with Calculated Measures.

The books I have seen so far shows me easy calculations like [Measures].[Total Sales] - [Measures].[Discount] but each combination of Partner/Product

### Named Sets vs. Calculated Members and the Filter Field Conundrum (Year-to-Date measures by company c

I’m going to describe our SSAS solution a bit and what I have in it so far in order to ask the question regarding “year-to-date” sales. This is part example and part question, I suppose. "The Filter Field Conundrum" sounds like it should be a high-tech Encyclopedia Brown case or something. Can't seem to find a similar situation through searching, although perhaps I'm wrong and this has been done before.

We have a data warehouse that contains our transactional detail for the last nine or so years. Tables are somewhat analogous to the AdventureWorks solution, with a table for Sales, a table for Customers, Geographic information, etc. The data warehouse has a time table that contains many of the usual bits of information one would expect:

Full Date (mm/dd/yyyy)
Month Number
Month Name
Day of Month
Day of Week
Day of Week Name
Day of Year
Week of Year
and maybe a few other typical fields.

Then we also have:
Working Day (bit, with a 1 indicating that this was a scheduled working day according to our company calendar, and a 0 indicating that it was not)
Working Day of Month
Working Day of Year
(these fields indicate that a day is the nth scheduled working day, according to our company calendar, for a given month or year)

So, for example, 5/1

### cell writeback question, normal and calculated measures

All,

I have writeback enabled for one of my cubes and it's working fine. I'm updating regular measures that are summed.

However I have a calculated measure that uses these regular mesures in it's calculation.

But when the regular measures are updated via writeback, the calculated measure stays the same. Writeback seems pretty useless if calculations that take those measures into account don't see the updated values. Am I missing something here? Do I need to alter the mdx of the calculated measure or something like that?

### Calculated measures limit?

Is there a limit to the number of calculated measures a cube can have?  Is there a performance hit after so many measures?

### Dimension Security on some level and access to higher levels for Calculated/Scoped Measures

Hi,

I'm trying to solve the following task:

I have a simple regular dimension e.g. calendar, there are some attributes: datekey (20100117, ...), month (201001, ...), year (2010).

There is a single user definded hierarchy called calendar:
datekey --> month --> year, the attribute relationships are configured accordingly.

There is one role that has only access to month 201001 (dimension data security - allowed memberset) - please be aware that I want to use "Visual Totals" or something simialr.

Now I have to calculate a measure: ([calendar].[calendar].[201001], [Measures].[sales]) / ([calendar].[calendar].[2010], [Measures].[sales])

How do I have to configure the security or calculate the measure that the sum of all months is used and by selecting the year only the Visual Total is shown?

Any hint is appreciated ;-)

Tom

### How to access a new database ( which i created ) in isqlplus ?

Hi.,

I created a new database with the help of Database Configuration Assistant !

I created with the scott account

Now i'm not able to connect to the database with the connect identifier with the scott account

The error i get is.,

ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.

Plz help !

### Classes created inside App_Code dir is ignored by the compiler

Hi,

I have the following problem programming in asp .net with visual studio 2008. If I insert a new class file, right clicking on "add new element -> class -> ecc..." directly inside the App_Code directory (or in its any subdirectory) the compiler and the smartTab do not see any custom namespace previously created in other classes, nor from other classes I can find the namespace and the class name defined within the new class file just inserted. The only way I found to correctly insert a new class file is create it right clicking on "add new element... ecc..." not in the App_Code (or sub) directory but rather in the root node with the name of the entire project, and then I can move it in the destination App_Code subdirectory, and it keeps working.

As a matter of facts it seems that is not important where the file IS but rather where I CREATED it: if I created a class from inside the App_Code it does not see anything and it is not seen by any other class, otherwise if I create it right clicking on the root node of the project it works and keeps workng even moving inside any subdir within the project.

I also tried to manually add the App_Code subdirs to the <Compilation> and <codeSubDirectories> tags of the Web.config file, but anything changed with this behaviour.

Does anybody know why?

<

### want to launch modal Popup from created User Event handler

hi,

I have a create user wizard on my page and in the event handler (Created User) I get extra information from the user

via textboxes within the aspx etc.

I then do a response.redirect to another page.

What I want to happen is this

When the CreatedUser Event is fired, I  want a Modal Popup to show up with a message Processing your registration.

once the registration code is processed it will close and the users get redirected.

On my ASPX I have the Modal PopUp and a Panel.

In the code behind in the handler I put ModalPop.show()

but this does not work.

thanks for any suggestions

### Custom Grid View Header - Grid view Row Created event vs Gridview row databound events ?

Hi Gurus ,

It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .

Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically  behaviour of both the events in !Postback and page.Postback .

Thanks a tonne in Advance and  any inputs will be valued and appreciated .

### file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?

Hi,

In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.

I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?

<div>
<br />

<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>

<asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
Text="Submit my Profile" />

### Delete spaces created by combining 2 fields

Howdy, this is kind of a continuation of an answer I got from this thread:  http://forums.asp.net/t/1592766.aspx

My users will enter a city/station where an incident occured, and the date.  The trigger below does work, but it will occasionally put spaces between the citystation and the date.  I think this happens when the citystaion name is not very long, but not sure.

(ex: city____08242010)

How can I make sure that if the incidentid is going to have spaces, that sql deletes those spaces?  I need the id to be space free.

Thanks!

===============================

ALTER

AS

### Adding carriage returns between 2 dynamically created controls in an HtmlTableCell

The title pretty much explains it. Here is what i'm trying to do...

Dim Txt As TextBox
Dim Cmd As ClickOnceButton.ClickOnceButton

Txt = New TextBox
Txt.ID = "txtComment_" & BookingNumber
Txt.CssClass = "TFAppControls"
Txt.TextMode = TextBoxMode.MultiLine
Txt.MaxLength = 500
Txt.Width = New Unit(95, UnitType.Percentage)

Cmd = New ClickOnceButton.ClickOnceButton
Cmd.DisableAfterClick = True
Cmd.CssClass = "TFAppButtons"
Cmd.EnableViewState = False
End Sub

On the line where i try and update the InnerHtml, i get the following error; "Cannot get inner content of  because the contents are not literal."

### Unable to search Custom User Property Created in User Profiles in SharePoint 2010

Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

### Workflow "Failed on Start (retrying)" when new item created by BizTalk SharePoint Adapter

We've been using the BizTalk SharePoint Adapter to load various different contents into a MOSS 2007 Document Library. The library has a MicrosoftÃÂ Office SharePoint Designer 2007 workflowÃÂ (sequential workflow created in Designer) which starts automatically when a new item is added to the Document Library. Or, at least, it eventually starts automatically.

ÃÂ

For some unknown reason--and this is what we're hoping some of you may have some ideas on--the workflow fails to start on the first try, producing the "Failed to Start (retrying)" message. When the timer job comes back the second time, the workflow starts successfully, but this causes us to loose five minutes of potential work time (not to mention making us look bad to the VPs and CTO because they see the failure message).

ÃÂ

In checking the log, I find the following pair of error messages each time the "Failed to Start (retrying)" status occurs:

ÃÂ

08/27/2007 13:49:43.24 ÃÂ w3wp.exe (0x0CA0)ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  ÃÂ 0x1438ÃÂ Windows SharePoint ServicesÃÂ ÃÂ  ÃÂ Workflow InfrastructureÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  ÃÂ 72fsÃÂ UnexpectedÃÂ RunWorkflow: Microsoft.SharePoint.SPException: <Error><CompilerError Line="1" Column="1" Text="The root activity type is invalid.&q

### How to get character count in 'Multiple Text 'column using Calculated Column?

Hi All,

I have a multiple text box in a list

I want

• A column which lists number of characters in multiple list column example 188, 199 etc
• Multiple character column must not have more than 200 chars
Is this possible?

Appreciate all the help!

-saumil

 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All