dbTalk Databases Forums  

Return all values of a dimension

comp.databases.olap comp.databases.olap


Discuss Return all values of a dimension in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alexb-div@laposte.net
 
Posts: n/a

Default Return all values of a dimension - 02-28-2008 , 07:37 AM






Hello,

I work on a SQL Server Business Analysis project to do reporting from
a database.

In order to allow custom values for each user, I write MDX statement
like :
[Dimension].[Hierarchy].[ValueToAllow]

Some users have to access to all values. Then, I try to write
statements like :
[Dimension].[Hierachy].[All]
[Dimension].[Hierachy].AllMembers
and so on.

I didn't succeed to get all values.

Could you help me please ?

Maybe my MDX statements are wrong. Or maybe there are some specific
things to do with Microsoft Business Analysis Visual Studio, I don't
know :-(

Regards,

Alex

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.