Creating a Watch List for dimension members -
04-30-2006
, 05:18 PM
Hi,
I have a dimension formed from three tables in a snowflake manner. I
would like to be able to tag certain members of this dimension for
viewing later in a separate view. Ideally the tagging will be done as
an action that can be initiated in Proclarity when right clicking a
dimension member. I thought this problem could be solved by making the
dimension writeback-able but the non-star schema prevents this.
The basic idea is to be able to interactively create a watch list for
certain key members of a dimension and then view only the watched
members later in a different view. Any ideas on how to best do this?
Cheers,
Donovan Hide. |