dbTalk Databases Forums  

virtual dimension ???

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


Discuss virtual dimension ??? in the microsoft.public.sqlserver.olap forum.



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

Default virtual dimension ??? - 08-16-2004 , 10:01 AM






Hi,
i have this problem:

dimensions
accounts (parent-child), time, planninglevel
measures
credit, debit

so far no problem but i like to put on top of the account
dimension another structure: financial statements
those elements are also parent-childs but the leave nodes
point to selected accounts.

accounts
+all
+-acc 001
Quote:
+-acc 00101
+-acc 00102
+-acc 002

financials
+all
+-fs 1
Quote:
+-fs 11 -> acc 00101
+-fs 12 -> acc 00102
+-fs 2 -> acc 002
+-fs 3 -> acc 00101
( more than one financialstatement can point the same
account !)

how can i achieve this (if possible) ?

Thanks for any help 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.