Hi,

How do we filter rows while building a dimension using MSAS 2005?

I used to do this using 'Source Table Property' in MSAS 2k.

I am not sure if i have to create a named query to achieve this instead of
creating the dimension staright from the view / table in the database?

Thanks,

Prasad.

Hi,
The SourceTableFilter from AS2000 no longer exists in AS2005 (because in
AS2005 the DataSourceView was introduced to separate the relational details
from the AS structures).
The solutions are, as you said, to create a named query in the
DataSourceView or to create the dimension straight from a view/table from
the relational database.
In case of a Partition, another option is to use QueryDefinition as Source
(this allows writing the SELECT sql statement as fact table for the
partition, thus you can add your own filter).

Adrian.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--


"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote

Thanks Adrian. That is what i thought.

Do you what happenned to the 'Aggregation Usage' property in MSAS 2005?

In MSAS 2000, In the cube editor, for mutli level dimensions, i used to set
'Aggrgataion Usage' property to 'Top Level Only' to mininmize the mumber or
exclude certain levels of a dimension from the aggrgegation strategy /
Dimension.

Please let me know.

Thanks,

Shyam.

"Adrian Dumitrascu [MS]" wrote:

Because AS2k5 is now attribute based, I believe you will find the
aggregation setting on a per attribute basis. (Levels purely exist as a
navigational aid) Sorry I can't check the exact name of the property as
my local AS2k5 is playing up right at this point in time

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <D1174A60-0471-4A1E-86F5-DE14428CBD41 (AT) microsoft (DOT) com>,
Prasad (AT) discussions (DOT) microsoft.com says...

It is in the cube editor. On the lower left hand side, there is a panel for
hierarchies and for attributes. Hierarchies is the default, you want to
click on Attributes. Then select the attribute you want to control. Then on
the right-hand side is the properties panel. You want a property called
"Aggregation Usage".

There are four values.
1 - NONE: means that the agg designer should never design an aggregation
with this attribute
2 - FULL: means that the agg designer should always consider this attribute
for aggregation
3 - UNRESTRICTED: leave it up to the agg designer
4 - DEFAULT: treats the attribute as NONE if it does not participate on a
natural hierarchy; UNRESTRICTED if it does

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote