dbTalk Databases Forums  

With Memebr creation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss With Memebr creation in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Faraz
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.