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.

>>

No comments:

Post a Comment