x

Should i create a named calculation in DSV or create member in MDX?

I have a cube with a value pre-calculated in the etl, that shows how many days a account is past due in the fact table. I need a way to either create a calculated member in MDX or create a named calculation in the dsv that will break down the days overdue as follows, and let me filter it in a cube. If it is between 1 and 29 days, then it is 'current'. IF it is 2o- 59 days, it is 'overdue', and so on. I am not sure the best way to do this. Any suggestions? Thank you!
more ▼

asked Jun 15, 2012 at 04:00 PM in Default

jgreer20092009 gravatar image

jgreer20092009
20 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It depends on your overal design and how frequently you are updating the cube, but whenever possible, it is better to put the caluclation of attributes into the lower levels (DSV or even better into the ETL process itself).

Once the attribute value is calculated in the loverl levers, than it's values are stored in the SSAS multidimensional model and SSAS will benefit from this (you can have aggregations defined for that attributes and also SSAS can build internal indexes to speedup filtering etc).

If you calculate a value in MDX scrip and then would like to filter the data based on this calculated value, SSAS will not benefit from the above mentioned.
more ▼

answered Jun 18, 2012 at 05:09 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x734
x172
x69

asked: Jun 15, 2012 at 04:00 PM

Seen: 1436 times

Last Updated: Jun 18, 2012 at 05:09 AM