Showing posts with label measure. Show all posts
Showing posts with label measure. Show all posts

Friday, March 30, 2012

If my cube don't have a measure how do I design cube ?

suggest I will try to design customer complaint system

to keep information about customer's complaint it will store ex. department , date , complainant , complaint message

I can't figure out which column will be measure

Anyone can guide me about cube that don't have a measure

Thanks for kindness

You can create a "count" measure which simply counts fact table rows, so no particular fact table column is selected for such a measure, For example, if you select "Count of rows" for Usage in the dialog box below, and select the Source table, then Source column selection will be disabled.

http://msdn2.microsoft.com/en-us/library/ms187698.aspx

>>

SQL Server 2005 Books Online

New Measure Dialog Box (SSAS)

...

Usage

Select the aggregation function to be used by the new measure.

Source table

Select the table from which the new measure is to be created.

Source column

Select the column in the table selected in Source table on which the new measure is to be based.

>>

Monday, March 26, 2012

IF calculated member

I have a discrete Measure, where 0 = ValueA and ValueB = 'greater than 0'.

The cube is aggregating the Measure but since it is discrete it has lost it's anlaytical value.

I would like to create a calculated member in the cube that adds 1 to the count if the value is greater than 0. Something like...

Iif([discreteMeasure]>0, Add 1 to calculated member count, Add 0 to count)

Any ideas how I can do this?

Thanks

Just do like yousaid, just creat a new count calc member with the following formula

IIF(Discretemeasure>0, 1, 0)

Since this calculated measure will also aggregate as a SUM it should give you the result you are looking for

|||

Adding to Thierry's answer, in AS2005, you can rely on recursion

iif(discretemeasure > 0, discretemeasure+1, 0)

Cheers,

Richard