MSBI

Question

Hello

I am New to MSBI  and still learning

I have few questions to ask !!! Kindly Help

I want  to see formulla behind my calculations in cube in SSAS from SSRS and Excel Sheet as a tool tip,I am using SqlServer2008 , BIDS 2012 and Excel 2007.I have set description property for the dimentions and measures  but i am not able to access those whatsoever.

How will  i do the same for calculations because i am able to see description property for simple measures  and dimentions in DSV and Cube View.

My second question is regarding , what is difference between named calculations in DSV and Calculations from cube.

How i will approach for calculations in cube

Regards

Answer 1

Hello

I am New to MSBI  and still learning

I have few questions to ask !!! Kindly Help

I want  to see formulla behind my calculations in cube in SSAS from SSRS and Excel Sheet as a tool tip,I am using SqlServer2008 , BIDS 2012 and Excel 2007.I have set description property for the dimentions and measures  but i am not able to access those whatsoever. (Not possible as far as I know. I will let experts have their say. Raise your voice here here)

How will  i do the same for calculations because i am able to see description property for simple measures  and dimentions in DSV and Cube View.

My second question is regarding , what is difference between named calculations in DSV and Calculations from cube.

How i will approach for calculations in cube

Regards

For named calculations http://msdn.microsoft.com/en-us/library/ms174859.aspx

SSAS Calculations http://www.purplefrogsystems.com/blog/2011/01/how-to-add-calculations-in-ssas-cubes/

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 2

Asrar,

Your first idea of revealing the MDX formulas within cube calculations on the UI in a tooltip is not something I think you can accomplish completely out-of-the-box.  I can think of something that's close, though.  You could create an SSRS report that would generate "calculation glossary" information for users, and the call that from a cube action (see http://msdn.microsoft.com/en-us/library/ms181171(v=sql.105).aspx).  The action will have visibility into selections made on the cell the user right-clicked on to generate the action, which you should be able to use in the report to make the report action context sensitive.

To get the actual MDX used in a calculation, I'd probably look at using AMO to pull it out of the script and store it in a SQL table used by the reporting idea above: http://msdn.microsoft.com/en-us/library/bb522603.aspx

For the DSV vs. MDX question, in a nutshell the DSV can create calculated columns on tables, but not aggregations.  If you need a simple calculated columns (e.g. NET=GROSS*DISCOUNT_PERCENT), DSV is fine, but 95% of your calculations will probably be in the cube MDX script.  Here's the start of the BOL doc on implementing MDX calculations inside the cube: http://msdn.microsoft.com/en-us/library/ms145492.aspx

---

Rob Kerr SQL Server MVP CTO, BlueGranite

Answer 3

thanks a lot Raunak

---

Asrar

Answer 4

Thanks a Lot dear ...

---

Asrar