dbTalk Databases Forums  

Bypassing a level in the Dimension

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


Discuss Bypassing a level in the Dimension in the microsoft.public.sqlserver.olap forum.



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

Default Bypassing a level in the Dimension - 05-20-2005 , 06:49 AM






Hi,

I have a dimension with four levels. The members at level 3 are not unique
among level members but unique among siblings. That is something like this:

L1A-----L2AA---L3A-----
Quote:
|_L3B-----
-----L2AB---L3A----
_ L3B----
L1B-----L2BA---L3A-----
|_L3B-----
-----L2BB---L3A----
_ L3B----

Is there any option in the Analysis Server by which I can analyze the sales
at level1 and 3 of the dimension bypassing the second level. That is
something like this:

L1A---L3A-----
Quote:
_L3B-----
L1B---L3A-----
_L3B-----
Where L1A--->L3A would be showing me the sum of the sales of the hierarchies
L1A---->L2AA--->L3A----- and
L1A---->L2AB--->L3A-----

Similary L1A--->L3B would be showing me the sum of the sales of the
hierarchies
L1A---->L2AA--->L3B----- and
L1A---->L2AB--->L3B-----

Same the case with the second member of the first level

--
Thanks
Akber.


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.