TI Process build for dynamic Scenario, Time etc.. Kindly help!

[Nirvan]

Hello Experts,

I am back to TM1/ IBM PA after a long long time, after having worked in it very briefly. Suffice to say, I am a beginner. Currently a very demanding project fell into my lap with extremely tight deadlines. (They brought me in because I was the only scapegoat)

Thus, I am requesting for some kind help with it. One part of this project involves modifying two existing TI processes that currently take in SCENARIO, MONTH, etc. as parameters and essentially build a large SQL query to perform delete/insert operations on data. This takes hours+ time. To reduce the time, the business wants to generate the cube view in TI process to include specific scenarios:

1. Static scenarios: Actual, Current Budget, Current Forecast
2. Dynamic scenarios: depending on the current month
Forecast 01-2025|Budget 01-2025|Forecast 02-2025|Budget 02-2025|Forecast 03-2025|Budget 03-2025|Forecast 04-2025|Budget 04-2025|Forecast 05-2025|Budget 05-2025|Forecast 06-2025|Budget 06-2025|Forecast 07-2025|Budget 07-2025"

Example:

Code: Select all

""Current Month: Jul"
"Current Year: 2025" 
"Next Year: 2026" 
"Current Month Number: 8" 
"Previous Month: ","Aug" 
"Generated Scenarios: Forecast 01-2025|Budget 01-2025|Forecast 02-2025|Budget 02-2025|Forecast 03-2025|Budget 03-2025|Forecast 04-2025|Budget 04-2025|Forecast 05-2025|Budget 05-2025|Forecast 06-2025|Budget 06-2025|Forecast 07-2025|Budget 07-2025"

Current code segment:

Code: Select all

[/b]#--- Scenario subset Creation segment----------------- 
vDimName='Scenario'; ExecuteProcess('Bedrock.Dim.Sub.Create.Leaf', 'pDimension', vDimName, 'pSubset', cSubsetName, 'pExclusions', '' ); ViewSubsetAssign (cCubeName, cViewName, vDimName, cSubsetName ); 
#---------------------------------------------------

What can be done to the above to generate the dynamic scenarios as mentioned above? Kindly help!!

Sincerely,
Nirvan
a certified beginner

[Wim Gielis]

I am back to TM1/ IBM PA after a long long time, after having worked in it very briefly. Suffice to say, I am a beginner. Currently a very demanding project fell into my lap with extremely tight deadlines. (They brought me in because I was the only scapegoat)

Not personally to you, but, ..., no one understands that this is a bad idea (if the changes are non-trivial) ?

This is Bedrock V3 ? Then you need Bedrock V4 processes too as V3 processes can call V4 processes.


Anyway, you will need the process 'Bedrock.Dim.Sub.Create.ByElement' in Bedrock V3 if you want to stick around with V3.

The parameter 'pElements' can be populated with your concatenated string of elements. I take it that you already have the code to populate such a variable with the correct element names (or aliases)? You will check that the string is not empty and there are elements to process?

There might also the Bedrock V4 processes that are probably a better fit to what you want to do, if it's just creating and populating a view on a cube. That's not for now if you have deadlines to meet.

Best regards,

Wim