Action to Create a Subcube (SSAS 2005) -
07-12-2006
, 02:58 PM
Using AS 2005, is it possible to make an action that would allow a user
to create a subcube based on the contents of a cell?
Business Scenario:
We have a Sales cube with a measure that counts distinct customers.
Using this, a user can identify the number of unique customers who
purchased a particular product.
I would like to be able to filter the cube based on those customers
IDs. In other words, create a subcube that would limit the cube to a
subset of customers until the user drops the subcube (using another
action). This would allow the user to answer the question: "Of the
customers who purchased X product, how many purchased Y product?"
I verified that it's possible to create and drop a subcube using
actions, but the create subcube action isn't context-sensitive.
Action Examples:
"create subcube [Cube] as
select ([Products].[Items].&[X]) on 0
from [Cube]"
"drop subcube [Cube]"
I've tried the following approaches so far, without much success:
1) Created a Drilldown action to return the Customer IDs for a
particular cell ... haven't figured out if it's possible to pass
those IDs to another action.
2) Created a calculation to return the unique names of each of the
dimensions. This identifies the set that defines each cell, but again,
I'm not sure how to use this calculation to create a subcube.
Any ideas?
Thanks, |