Create a Customized Measurement in Excel 2013

Question

Create a Customized Measurement in Excel 2013

akirajt

Right there with Babe

Points: 762
More actions
October 30, 2013 at 3:01 pm

#284378

Goal:
Achieve same result in Excel 2013 by using MDX but I failed. I need help to achieve the result in Excel with MDX code.
Problem:
The task is to achieve the same result, based on the picture, for excel 2013.
Informaiton:
The picture is based on SSAS management studio.
Table "a" is a dimension table and measures are taken from a fact table.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

I can't see the picture, try posting it as an attachment to your post.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akirajt Right there with Babe Points: 762 More actions · Answer 2

I have uploaded the picture and reviewed it.

I have an another link with same message in a different forum named MSDN forum

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5c442c89-f608-43e4-8d8e-c27d346fb719/create-a-cuomstized-measurement-in-excel-2013?forum=sqlanalysisservices#5c442c89-f608-43e4-8d8e-c27d346fb719

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 3

The link below shows how to add a calculated member when using a pivot table related to a cube.

http://blogs.office.com/b/microsoft-excel/archive/2012/10/15/calculated-member-and-measures-in-excel-2013.aspx

If this is going to done repeatedly then it would be best to centralise the calculation with the cube calculation tab.

If you do not want to use a pivot table then maybe you could use the cubevalue function within Excel. Given that you have created a link to the cube and stored the connection in Excel.

= cubevalue("CubeName","[a]..[c].[3 - e]","[Measures].[aaa]") -

cubevalue("CubeName","[a]..[c].[5 - er]","[Measures].[aaa]") -

cubevalue("CubeName","[a]..[c].[7 - era]","[Measures].[aaa]") -

cubevalue("CubeName","[a]..[c].[8 - eran]","[Measures].[aaa]")

Fitz

akirajt Right there with Babe Points: 762 More actions · Answer 4

Thank you for your help!

I have a similar and another question but in a different context.

How should I enable to do If I want to create a measurement in SSRS without using SSAS?

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 5

akirajt (10/31/2013)
Thank you for your help!
I have a similar and another question but in a different context.
How should I enable to do If I want to create a measurement in SSRS without using SSAS?

You are using a cube as a source so must use SSAS. If you are thinking about going straight to the DW then you could use TSQL.

Please clarify what you want to use?

Fitz