dbTalk Databases Forums  

byAccount - question

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


Discuss byAccount - question in the microsoft.public.sqlserver.olap forum.



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

Default byAccount - question - 07-31-2006 , 05:27 PM






my Finance Cube currently consists of one measure (amount) aggregated by
Account. In addition i have defined one dimension (balance sheet) as an
account dimension . when trying to add a second account dimension
(balance sheet short) i receive the following error:


A measure with 'ByAccount' aggregation function requires exactly one
dimension with Type = 'Accounts' with exactly one attribute with Type =
'Account'. In addition, that attribute needs to be marked as parent if
the dimension is parent-child.

any workaround? meaning what do i have to do in order to have several
account dimensions in one cube using the same measure?
Thank you very much for your help.
Peter
Vienna

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.