in a way desribed here?

I have, say, Product and Time dims. which are same across all cubes. And I
have measures (aggregations) for each product and time levels. This is
simple to do, with a single cube.

But I also have the user-specific aggregations-measures (ie. time-prod-user).
With 'user' , the aggregated values are different...

If I am to use the shared dims(prod and time) across all cubes I use, but
with user-specific measures (or xyz-specifc..), how to achive this?. For
example, if I drag and drop 'user' into the report area (say, in excel-pivot
table), then it should show user-specific aggregated values, replacing the
globally aggregated values.

Please explain how this is possible.. OR is there any other possibility of
implementing this type of requirement?

Thank you
philipus


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

Please check Dynamic Security in Analysis services using cube roles

Im sorry, I could not get what you mean here. Was it confused with the 'user'
that I used in my description? What I meant by 'user' was : The user of a
product . ie. I wanted to know the possibilities for:

a. What is the maximum usage of THIS PRODUCT today?
b. What is the maximum usage of THIS PRODUCT by THIS USER today?

Q. The result from these two are different though the value could be the
same. So how to implement the OLAP for such kind of data?

Thank you! - philipus

pras wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

OK,I assume you have User,product and Time dimension

What is the maximum usage of THIS PRODUCT today?
Calculated member:Max_usage :I assume sales as measure
Max(Time.Currentmember,[Measures].[Sales]) and put the Product on the
rows
Filter axis selecting the time.

What is the maximum usage of THIS PRODUCT by THIS USER today?
Calculated member:Max_usage_User
:Max(Crossjoin({product.Currentmember},{User.Curre ntmember}),[Measures].[Sales])


Please let me if it satisifes your queries

Regards,
Prasanna

Philipus via SQLMonster.com wrote:

You are bit closer it seems. Thanks!
But I would like to clarify certain things fastly, and in bits and pices
(instead of writing huge paras). Would it be possible to chat or you just
want me to explain in detail?

Philipus

pras wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

BTW: I request you to look into my other thread "Implementing time-based
usage statistics". That is the basis. Just let me know if you get the point...
..

Philipus

pras wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

Please explain in detail.

Philipus via SQLMonster.com wrote: