dbTalk Databases Forums  

Top 10 data

comp.databases.olap comp.databases.olap


Discuss Top 10 data in the comp.databases.olap forum.



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

Default Top 10 data - 03-31-2004 , 10:50 PM






Hi everyone,
I am facing some problem on creating Top 10 data in Cube, the cube
structure is like below :
Dimension A :
Level 1 : Region
Level 2 : Model
Level 3 : Top 10 Product (for particular model)
In fact I am trying to build a calculated member in the cube for
top 10 record 'TopCount(Product.members,10,Sales)'
, but it keep on prompt out "Formula error - can not convert set to
expression - in a Top or Bottom function".
Anyone got any idea?

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.