dbTalk Databases Forums  

Restricting Higher level dimension

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


Discuss Restricting Higher level dimension in the microsoft.public.sqlserver.olap forum.



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

Default Restricting Higher level dimension - 09-19-2006 , 02:33 AM






Hi All,

I am working with MS Analysis Server 2000 using asp.net 1.1 for user
interface. When I query analysis server for lower level dimension
values the OleDBReader is returning higher level dimension values. From
reader I am creating data table and binding it to datagrid. Is there
any way to restrict higher level dimension values from being returned.

For example If user wants to view only month data in Time Dimension
(which is further drilled down to Year,Quarter and Month levels with
corresponding ranks) the output is containg year,quarter and month
info.

Thanks in Advance.

Raghavendra


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.