Hi all,
we have created an application for web client with multiple views. These views are built upon multiple cubes with nearly the same dimensionality.
Is it somehow possible to fix context dimensions to use the same member for all of these views? Ie. when I select specific product in first view I want to have this product selected in all next views.
Could anyone give me a clue how to do this?
Thanks,
Vladino
Fixed point-of-view in all cube views
-
- MVP
- Posts: 3661
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Fixed point-of-view in all cube views
You can't do this with views per se (unless navigating to views via workflow, either old workflow or th enew contributor).
However if you set up either classic slice or active form reports and save them to application folders then it is quite simple to set up contextual navigation of title elements via action buttons.
However if you set up either classic slice or active form reports and save them to application folders then it is quite simple to set up contextual navigation of title elements via action buttons.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Fixed point-of-view in all cube views
Actually there are two ways of doing this and they both involve subsets. One uses static subsets and the other dynamic. They both require you to create all the views you want adhering to this using subsets. In your example that is the Product dimension.vladino wrote:Hi all,
we have created an application for web client with multiple views. These views are built upon multiple cubes with nearly the same dimensionality.
Is it somehow possible to fix context dimensions to use the same member for all of these views? Ie. when I select specific product in first view I want to have this product selected in all next views.
1) First option is a static subset. Create a static subset, let's call it Static_Products and give it one member, doesn't matter which. Now, when you create your views use this subset for the Product dimension selection. Now all the views will have this product. When a user opens that view and changes the subset, to select another product, as long as they save over the original subset then all the views will now point to the new product. The problem with this is that the users have to have the ability to save public subset, meaning they need admin privileges over the Product dimension. Not necessarily a good idea.
2) Second option is a dynamic subset. Create a control cube, let's call it Choice, that has two dimensions, Choice_Item (that has one "N" element called Product_Choice), and Measure_PC (that has one "S" element called Value). Store your choice of product in the intersection of Choice_Item and Value. Let's say we put "Widget" in there. Now, we create a dynamic subset called Dynamic_Products that we're going to use in the views we talked about needing in #1 above. The MDX query behind this subset would look like:
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Product] )}, [Choice].([Choice_Item].[Product_Choice],[Measure_PC].[Value]))}
Every view will now have "Widgets" as it's product. To change this all you have to do is replace "Widgets" with something else in the Choice cube. If you want to get fancy you can make the }Clients dimension part of this cube so that each client can have their own product selection. Then the MDX looks like this:
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Product] )}, [Choice].((STRTOMEMBER("[}Clients].["+USERNAME+"]"),[Choice_Item].[Product_Choice],[Measure_PC].[Value]))}
and the subset will evaluate to a different product depending on the user.
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Fixed point-of-view in all cube views
Hi
Another way to do that is to create private views for each user. The private views will need to have private subsets on the relevant dimensions and these private subsets will need to be shared across all the views in the different cubes. Eg if you have a project dimension in three cubes then perhaps the user sets the private default subset to the project that they want to work on. The private default subset is then used in the views on the P&L, Balance Sheet, and Cash Flow cubes. Then when they change the private default subset then all the views will change in step.
I have something via the API that will let you generate a private copy of all public views replacing a selected dimension with a private default subset. You can then copy this to all users.
Another way to carry over context is via a Drill Thru to the other cubes, but that implies that the users must navigate from cube to cube via a drill thru which is not ideal.
Other things may also be possible in other front ends such as Cognos 8 BI.
Regards
Paul Simon
Another way to do that is to create private views for each user. The private views will need to have private subsets on the relevant dimensions and these private subsets will need to be shared across all the views in the different cubes. Eg if you have a project dimension in three cubes then perhaps the user sets the private default subset to the project that they want to work on. The private default subset is then used in the views on the P&L, Balance Sheet, and Cash Flow cubes. Then when they change the private default subset then all the views will change in step.
I have something via the API that will let you generate a private copy of all public views replacing a selected dimension with a private default subset. You can then copy this to all users.
Another way to carry over context is via a Drill Thru to the other cubes, but that implies that the users must navigate from cube to cube via a drill thru which is not ideal.
Other things may also be possible in other front ends such as Cognos 8 BI.
Regards
Paul Simon