With Memebr creation -
03-10-2006
, 05:55 AM
--------------------------------------------------------------------------------------------------------
DIMENSION STRUCTURE
--------------------------------------------------------------------------------------------------------
Dimension Time
Levels Year
Quarter
Month
Day
--------------------------------------------------------------------------------------------------------
SECURITY SETTINGS
--------------------------------------------------------------------------------------------------------
Top level Day
Bottom level Day
--------------------------------------------------------------------------------------------------------
I m applying security for the dimension and set Top level and Bottom
level as same. e,g. the last level of the dimension.
Now i want to create a member using WITH clause. what are the way to
create this member ? Will i have to create the member at the last level
? Is it mandatory or can i create it on any other upper level.
---------------------------------------------------------------------------------------------------------
WITH MEMBER [Time].[MyMember] AS '[Time].[Any Day Member] + any Number
or Calculation'
SElect {} .........
-----------------------------------------------------------------------------------------------------------
Thanks in Advance. |