September 23, 2008 at 4:57 pm
I need to create calculations for the measures in my cube. Is it better (more efficient) to do these calculations in a view in the database and use the view in my Data Source View in SSAS, or would it be better to use my base tables in SSAS and create a Named Calculation for my measures? Or … is there even a better way??
Thanks in advance for your advice!
September 23, 2008 at 10:56 pm
hi,
Both you can use.but the named calculation is the one i prefer because its an feature of SSAS 🙂 .
vijay
September 24, 2008 at 3:59 pm
I suppose these two things are the same.
The difference is that the SSAS would generate a SELECT query and the calculation will be in there aliased with a name, but when you create a view the SELECT generated by SSAS will dumbly select from this view.
Either way, no difference
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
September 24, 2008 at 4:01 pm
Oh yeah. should have mentioned that SSAS named calculations is nothing more than the DB engine calculations palced in the DSV. SSAS does not calculate anything really
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
September 24, 2008 at 4:09 pm
Good to know performance isn’t an issue either way. Thank you both for your replies.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply