dbTalk Databases Forums  

Action to Create a Subcube (SSAS 2005)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Action to Create a Subcube (SSAS 2005) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
christian.debry (AT) gmail (DOT) com
 
Posts: n/a

Default 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,


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.