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. |