Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculated Cells - Dynamic subcube defination

Status
Not open for further replies.
nirengi

nirengi

Programmer
Feb 17, 2009
1
0
0
TR
Hi,

I'm trying to use "dynamic level" instead of "single level" selection by MDX. Can anyone have an idea?

I'm using below calculated cell which is working fine. But I wanna use "lowest level" of geography dimension instead of [DM]


Calculation Subcube: {[Measures].[Sales Value 02]}, [GEOGRAPHY].[DM].MEMBERS
Calculation Condition: ""
Calculation Value: CalculationPassValue([Measures].[Sales Value 02] / 100 * StrToValue([GEOGRAPHY].Properties("Percentage")),0)
 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
64
Benedito Almeida
Benedito Almeida
nodoubtom
  • Locked
  • Question
SSAS 2008 - Duplicated calculated measure values
Replies
0
Views
30
nodoubtom
nodoubtom
dimitemma
  • Locked
  • Question
MDX Date Range calculated member
Replies
1
Views
52
RiverGuy
RiverGuy
Flybridge
  • Locked
  • Question
Calculated member and ParallelPeriod 1
Replies
8
Views
72
Flybridge
Flybridge
eo
  • Locked
  • Question
MDX Calculated member to compare dates for SLA purposes
Replies
1
Views
41
RiverGuy
RiverGuy

Part and Inventory Search

Sponsor

Back
Top