dbTalk Databases Forums  

MSAS 2005 - Dimnesion Properties question

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


Discuss MSAS 2005 - Dimnesion Properties question in the microsoft.public.sqlserver.olap forum.



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

Default MSAS 2005 - Dimnesion Properties question - 10-27-2005 , 01:45 PM






Hi,

1. Sorce Table FIlter.

I want to restrict some rows in a table while creating the dimension. I
accomlished this using the 'Source Table Filter' property for the dimension
in the Dimension Editior in MSAS 2000.

where i can set this for a dimension in 2005?

May be i have to do this in the DSV as a 'named query'.

2. Aggregation Usage: 'Top Level Only'

In MSAS 2000, with in the cube editor, we can set the Aggregation Usage
property for each dimension to 'Top Level Only', 'Custom', 'Standard'.

3. MSS Process Log:

Also what is the location for the MSAS process log in MSAS 2005. I do not
see that.

Please let me know where can we set this property in MSAS 2005?


Thanks,

Venkat.

Shyam.

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.