Hi, All!

I need help. How can I with MS AS 2K realize next task.

Among others we have Product dimension. The lowest level in it is model.
Each model can have several properties (width (A,B,C...),
material(silk, lether...), ...(...)). Users can add and change these
properties
dynamically.

Is it possible to build such one(!) dimension (ModelProperties) using
which
we can analyze sales by these properties?

Or the only chance is to build several dimensions and every time when
they
have changed we should manualy delete useless and add new one?

thanks
-- -
With best regards,
Andrey Savchenko

If I understood correctly, you want to analyze dynamically by many
member properties at run-time, rather than making a dimension for each
property. Maybe this post can help you?

http://groups.google.com/groups?q=cr...microsoft.publ
ic.sqlserver.olap&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sql
server.olap&selm=bf90cde3.0208281937.3875aa5%40pos ting.google.com&rnum=3
Subject: Re: Distinct Sum Queastion
View: Complete Thread (4 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2002-08-28 20:37:59 PST

There is a simple MDX solution, using CreatePropertySet():
'CreatePropertySet([Product],
[Product].[Brand Name].Members,
[Product].CurrentMember.Name)'

SELECT {[Unit Sales]} ON COLUMNS,
Order(BrandNames,[Product].CurrentMember.Name) ON ROWS

FROM Sales
Since [MS] has not documented this (??) in SQL BOL, refer to
a SQL Server Magazine article by Russ Whitney of Proclarity:

http://www.sqlmag.com/Articles/Index...rticleID=16302
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!