All, my goal is to have a picklist that is controlled via a subset. This subset is updated after a month-end closing process putting the most recent month with data at the top of the list. I would like the page to open on the first item in the subset. However, when opening the page it always reverts to the month the page was last saved on.

Has anyone had success having pages update automatically when a subset is updated?

Note, I have been able to set the page to a subset based on one month. If this month is changed the page will open with the correct time period. The issue arises regarding multiple selections in a picklist.

Thanks in advance,

------------------------------
JOHN LICAUSE
------------------------------

#PlanningAnalyticswithWatson

John:

Have you considered using a dynamic MDX subset instead of a static subset? It might even be as simple as using the TM1SUBSETTOSET() MDX function to reference the subset that you are maintaining manually.

Or if you want to stop having to maintain the manual subset you can use a "Global Variables"-type cube where you store system settings. You would then update the setting in the Global Variables cube as part of your close process, and the MDX subset would read that value and generate the subset from there. How feasible this is does depends of course on what you have in the subset and may require some additional attributes etc. but it is nice when you can make it work!

Before going too far though, I'd first test the hypothesis that a dynamic MDX subset would help. But it might :-)

Regards,
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com
------------------------------

Original Message:
Sent: Mon April 26, 2021 03:27 PM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

All, my goal is to have a picklist that is controlled via a subset. This subset is updated after a month-end closing process putting the most recent month with data at the top of the list. I would like the page to open on the first item in the subset. However, when opening the page it always reverts to the month the page was last saved on.

Has anyone had success having pages update automatically when a subset is updated?

Note, I have been able to set the page to a subset based on one month. If this month is changed the page will open with the correct time period. The issue arises regarding multiple selections in a picklist.

Thanks in advance,

------------------------------
JOHN LICAUSE
------------------------------

#PlanningAnalyticswithWatson

AG, thanks for the help. We believe this will work.

On a related note, each of our plants has a unique department list. We have MDX that is pulling the active departments for the plant selected (Current Member). The department list will update within the view on the page when changing plants. However, the dimension tile (picklist) that has been pulled out of the view does not update along with the department dimension within the view. Would the same expression TM1SUBSETTOSET() help in this scenario as well? I have attached the MDX we are currently using below.

{FILTER(TM1SORT(TM1FILTERBYLEVEL(TM1DRILLDOWNMEMBER({[PovaDepts].[Manufacturing Productive]} , ALL , RECURSIVE) , 0 , 2) , ASC) , (((((((Pova.([PovaType].[oov_AllN],[AllocKey].[Total],[PovaPlants].CURRENTMEMBER,[PovaAccts].[Combo],[Wk-Mon].[Combo]) <> 0))))))))}

Simply put, how do we get the departments to change when selecting a different plant.

Thanks again,
John

------------------------------
JOHN LICAUSE
------------------------------

Original Message:
Sent: Tue April 27, 2021 03:50 PM
From: Ann-Grete Tan
Subject: Update Time Period with Subset Using Tile as Picklist

John:

Have you considered using a dynamic MDX subset instead of a static subset? It might even be as simple as using the TM1SUBSETTOSET() MDX function to reference the subset that you are maintaining manually.

Or if you want to stop having to maintain the manual subset you can use a "Global Variables"-type cube where you store system settings. You would then update the setting in the Global Variables cube as part of your close process, and the MDX subset would read that value and generate the subset from there. How feasible this is does depends of course on what you have in the subset and may require some additional attributes etc. but it is nice when you can make it work!

Before going too far though, I'd first test the hypothesis that a dynamic MDX subset would help. But it might :-)

Regards,
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com

Original Message:
Sent: Mon April 26, 2021 03:27 PM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

All, my goal is to have a picklist that is controlled via a subset. This subset is updated after a month-end closing process putting the most recent month with data at the top of the list. I would like the page to open on the first item in the subset. However, when opening the page it always reverts to the month the page was last saved on.

Has anyone had success having pages update automatically when a subset is updated?

Note, I have been able to set the page to a subset based on one month. If this month is changed the page will open with the correct time period. The issue arises regarding multiple selections in a picklist.

Thanks in advance,

------------------------------
JOHN LICAUSE
------------------------------

#PlanningAnalyticswithWatson

Hi,

I think you will run into the same issue I outlined here when dragging dims outside the cube view:

https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=92c0a834-ac0c-4fa5-af6c-537c8274e68a&CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b&tab=digestviewer#bm7a0f8acc-33fd-49c3-981b-dfbe28d545b1

Hopefully IBM are going to address this, they said they were looking to extend the synchronisation to facilitate this.

regards,

Mark

------------------------------
Mark Wragg
------------------------------

Original Message:
Sent: Wed April 28, 2021 09:46 AM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

AG, thanks for the help. We believe this will work.

On a related note, each of our plants has a unique department list. We have MDX that is pulling the active departments for the plant selected (Current Member). The department list will update within the view on the page when changing plants. However, the dimension tile (picklist) that has been pulled out of the view does not update along with the department dimension within the view. Would the same expression TM1SUBSETTOSET() help in this scenario as well? I have attached the MDX we are currently using below.

{FILTER(TM1SORT(TM1FILTERBYLEVEL(TM1DRILLDOWNMEMBER({[PovaDepts].[Manufacturing Productive]} , ALL , RECURSIVE) , 0 , 2) , ASC) , (((((((Pova.([PovaType].[oov_AllN],[AllocKey].[Total],[PovaPlants].CURRENTMEMBER,[PovaAccts].[Combo],[Wk-Mon].[Combo]) <> 0))))))))}

Simply put, how do we get the departments to change when selecting a different plant.

Thanks again,
John

------------------------------
JOHN LICAUSE

Original Message:
Sent: Tue April 27, 2021 03:50 PM
From: Ann-Grete Tan
Subject: Update Time Period with Subset Using Tile as Picklist

John:

Have you considered using a dynamic MDX subset instead of a static subset? It might even be as simple as using the TM1SUBSETTOSET() MDX function to reference the subset that you are maintaining manually.

Or if you want to stop having to maintain the manual subset you can use a "Global Variables"-type cube where you store system settings. You would then update the setting in the Global Variables cube as part of your close process, and the MDX subset would read that value and generate the subset from there. How feasible this is does depends of course on what you have in the subset and may require some additional attributes etc. but it is nice when you can make it work!

Before going too far though, I'd first test the hypothesis that a dynamic MDX subset would help. But it might :-)

Regards,
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com

Original Message:
Sent: Mon April 26, 2021 03:27 PM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

All, my goal is to have a picklist that is controlled via a subset. This subset is updated after a month-end closing process putting the most recent month with data at the top of the list. I would like the page to open on the first item in the subset. However, when opening the page it always reverts to the month the page was last saved on.

Has anyone had success having pages update automatically when a subset is updated?

Note, I have been able to set the page to a subset based on one month. If this month is changed the page will open with the correct time period. The issue arises regarding multiple selections in a picklist.

Thanks in advance,

------------------------------
JOHN LICAUSE
------------------------------

#PlanningAnalyticswithWatson

John:

I agree with Mark. If you are using the subset in a context where the MDX is not being re-evaluated  each time, I am afraid TM1SUBSETTOSET() will not give you anything different from any other MDX.

That said (and let me say that I may be misunderstanding what you are looking for) I wonder if the TI Action Button parameter synchronization feature added in PAW 2.0.62 might be used in some creative way to address your problem?
https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=2wnm12-synchronize-parameters-action-button-that-runs-turbointegrator-process


Regards
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com
------------------------------

Original Message:
Sent: Wed April 28, 2021 09:46 AM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

AG, thanks for the help. We believe this will work.

On a related note, each of our plants has a unique department list. We have MDX that is pulling the active departments for the plant selected (Current Member). The department list will update within the view on the page when changing plants. However, the dimension tile (picklist) that has been pulled out of the view does not update along with the department dimension within the view. Would the same expression TM1SUBSETTOSET() help in this scenario as well? I have attached the MDX we are currently using below.

{FILTER(TM1SORT(TM1FILTERBYLEVEL(TM1DRILLDOWNMEMBER({[PovaDepts].[Manufacturing Productive]} , ALL , RECURSIVE) , 0 , 2) , ASC) , (((((((Pova.([PovaType].[oov_AllN],[AllocKey].[Total],[PovaPlants].CURRENTMEMBER,[PovaAccts].[Combo],[Wk-Mon].[Combo]) <> 0))))))))}

Simply put, how do we get the departments to change when selecting a different plant.

Thanks again,
John

------------------------------
JOHN LICAUSE

Original Message:
Sent: Tue April 27, 2021 03:50 PM
From: Ann-Grete Tan
Subject: Update Time Period with Subset Using Tile as Picklist

John:

Have you considered using a dynamic MDX subset instead of a static subset? It might even be as simple as using the TM1SUBSETTOSET() MDX function to reference the subset that you are maintaining manually.

Or if you want to stop having to maintain the manual subset you can use a "Global Variables"-type cube where you store system settings. You would then update the setting in the Global Variables cube as part of your close process, and the MDX subset would read that value and generate the subset from there. How feasible this is does depends of course on what you have in the subset and may require some additional attributes etc. but it is nice when you can make it work!

Before going too far though, I'd first test the hypothesis that a dynamic MDX subset would help. But it might :-)

Regards,
AG

------------------------------
Ann-Grete Tan
Chief Strategy & Marketing Officer
QueBIT Consulting

Analyze. Plan. Achieve.
https://quebit.com

Original Message:
Sent: Mon April 26, 2021 03:27 PM
From: JOHN LICAUSE
Subject: Update Time Period with Subset Using Tile as Picklist

All, my goal is to have a picklist that is controlled via a subset. This subset is updated after a month-end closing process putting the most recent month with data at the top of the list. I would like the page to open on the first item in the subset. However, when opening the page it always reverts to the month the page was last saved on.

Has anyone had success having pages update automatically when a subset is updated?

Note, I have been able to set the page to a subset based on one month. If this month is changed the page will open with the correct time period. The issue arises regarding multiple selections in a picklist.

Thanks in advance,

------------------------------
JOHN LICAUSE
------------------------------

#PlanningAnalyticswithWatson