Corentin,
No exact solution, but I wanted to share my thoughts with you.
In Excel Workbooks/Websheets you can setup cascading prompts using the selection of an element in one SUBNM cell to determine which subset is used in another SUBNM cell. You might use element attributes in one dimension to store a subset names in another dimension.
The only other thing I can suggest is using the single cell widget feature in combination with picklist cells and rules on a picklist cube. The single cell widget feature is documented here:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/t_paw_cell_widget.html. This single cell will appear as a picklist if the cell you select to 'Add to Sheet' is a picklist cell. A picklist can set to be the list of members in either a dimension or subset (see:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/c_picklisttypes_234567.html).
You cannot sync a cubeview widget in PAW with a values in the single cell widgets. I think you could try creating MDX based subsets in that reference the selected values in the picklist cells. Because of the lack of synchronization you would need to refresh the book or cubeview to see results of what you picked. The other problem is that you will need a way to clear or reset the picklist single cell widgets. Maybe an action button that runs a Ti to clear the cell values.
I think a good idea for an enhancement request would be a cascading prompt widget that can be synchronized to other widgets in the book.
------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------
Original Message:
Sent: Tue January 21, 2020 04:52 AM
From: Mark Hackett
Subject: PAW - Context dimension defined by another
Hi Corentin,
Unfortunately I don't have enough experience using the widgets to know if this is possible. The example I was giving was just using standard cube views and subsets - this worked for me, but I wasn't using widgets for filtering in this instance.
Sorry!
Mark
------------------------------
Mark Hackett
Original Message:
Sent: Mon January 20, 2020 08:10 AM
From: Corentin Gombert
Subject: PAW - Context dimension defined by another
Hi Mark,
Thanks a lot for your response !
I keep it if the need appears but I'm not sure for my current issues,
Elements of dimensions we're using are not stable across tabs and we need a fluent navigation,
For instance, there are 2 dimensions : Cost Center and Internal Order, I want that when a user choose a cost center, the widget of internal order just contains IO of this cost center and the user could change the cost center in the tab or another.
it's similar to the Perspective/PAX practice :
Range A1 : =SUBNM("CostCenter";"Level_0";0);
Range A2 : =SUBNM("InternalOrder";A1;1);
With your example, is there a possibility to write the version when I select one in a context filter dimension ?
Thank you,
Corentin
------------------------------
Corentin Gombert
Original Message:
Sent: Thu January 16, 2020 04:14 AM
From: Mark Hackett
Subject: PAW - Context dimension defined by another
Hi Corentin,
One method I have used in PAW is to have one cube on the first tab where I make my selection from a picklist in the cube (e.g. select current version). I have a rule on the ElementAttributes cube for the relevant dimension which sets a flag (e.g. Current_Version_Flag) based on the selected value in the cube (in this example, the cube where I select the version is called "Version Control"):
['Current Version Flag'] = S:
IF (ATTRS('Version',!Version,'Caption') @=
DB('Version Control',
'Version to Process',
'Select Version to Process'),
'Y',
'');
Then on the Version dimension itself I have a dynamic subset using an expression such as this: {FILTER( {TM1SUBSETALL([Version])}, [Version].[Current Version Flag] = "Y")}.
On subsequent tabs, I have various cubes displayed - they all use Views which utilize the dynamic subset, so the user just selects the required version on the first tab, and when they move to the other tabs that version is automatically selected on all relevant views. I haven't tried it with multiple selections, but I'm sure this concept would work in that case also.
Hope this helps,
Regards,
Mark
------------------------------
Mark Hackett
Original Message:
Sent: Tue January 14, 2020 08:10 AM
From: Corentin Gombert
Subject: PAW - Context dimension defined by another
Hi everyone,
Have you got a tip to determine the proposed elements of a dimension in a book by the selection of another in PAW ?
My problem is : I have 2 (or more) dimension which have to be dependent, when i select an element X from Dim A, I want that the user just can select elements from a subset define by X. It's a waterfall issue.
I've tried several solutions but I'm not satisfied with it.
> By a PAX websheet, there is synchronization issues.
> By a MDX with .CurrentMember.Name, it's possible but I can't work outside of a view containing both dimension and It's impossible to get the context selector out of the view
> By a MDX which will look a value in a cube to define the name of the subset after a websheet write this value after the selection of dim A. It's onerous and the process is too complex to be efficient and immediate.
Thanks a lot,
Corentin
------------------------------
Corentin
------------------------------
#PlanningAnalyticswithWatson