September 8, 2010 at 3:32 pm
In SSAS I have deployed a cube named HCSALES.This cube has 4 measures such as:
- UnitSold
- SalesValue
- UnitReturn
- ReturnValue
Now I want to add a calculated member bu using my DimProduct dimension. This dimension has an attribute named ITPP. And my desired calculated member formula is like this:
SalesValue - (ITPP x UnitSold)
How can do this? Any idea?
Please help
September 13, 2010 at 3:41 am
you will need to do it in MDX
use SSMS to create an MDX query, it's easier than doing it in VS, you get the intellisense and drag-n-drop
it will be something like
[DimProductMax].CurrentMember * [Measures].[UnitSold]
September 13, 2010 at 4:40 am
darth vodka (9/13/2010)
you will need to do it in MDXuse SSMS to create an MDX query, it's easier than doing it in VS, you get the intellisense and drag-n-drop
it will be something like
[DimProductMax].CurrentMember * [Measures].[UnitSold]
Well what about the SOLVE_ORDER??
Raunak J
September 14, 2010 at 7:15 am
For now, don't worry about solve order. Sometimes it's important, but probably not in this case.
September 15, 2010 at 3:11 am
RonKyle (9/14/2010)
For now, don't worry about solve order. Sometimes it's important, but probably not in this case.
Ron,
The user has not mentioned about the nature of SalesValue measure.
If the SalesValue measure is a calculated measure...definately Solve order needs to be mentioned
Raunak J
September 15, 2010 at 3:44 am
My point was not that solve order wouldn't matter. It was simply not to get hung up on that. Try the formula first. I have seen examples of good uses of solve order. Despite some complex calculations I have done, however, including linear regressions, I have not yet run across a situation where I have had to set that manually in SSAS.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply