TM1 Forum

For those following along - since the VBS script was initially placed on the Rich Tier desktop, which is going away, and the Data Tier does not and will not have Excel installed, then I had to stop pursuing this approach. I am now pivoting my efforts into developing a python script to execute TO and...

It would be great if I could get it to pause on the two Excel-based processes... I'm guessing the tm1 authentication piece is preventing you from calling the excel-based processes via a vbs script and running unattended? If not, you could call the vbs from a TI and simply make that part of the exec...

It would be great if I could get it to pause on the two Excel-based processes... I'm guessing the tm1 authentication piece is preventing you from calling the excel-based processes via a vbs script and running unattended? If not, you could call the vbs from a TI and simply make that part of the exec...

Is this thread similar ? https://community.ibm.com/community/user/businessanalytics/discussion/what-is-the-paw-replacement-for-applications-in-tm1-architect Thank you Win! It is indeed the same challenge. We run a number of wrapper-rule processes, where possible, but typically our month-end process...

Good Afternoon, We have utilized the "Application" folder structure within Architect/Perspectives in order to place Excel and TI Processes in execution order for Month-End, Year End and Forecasting processes. Here is a basic example: Applications >Month End Processing > Step A > Excel Base...

I think the easiest way to solve this (assuming the GUI is PAfE or Perspectives or Apliqo UX) would be to have a helper dimension which encodes valid reporting selections. (This dimension is artificial and just for lookups and isn't in the cube.) The helper dimension would have attributes for Accou...

It's not possible to answer your question without you first providing more information about the current structure of the GL cube. What are the dimensions of the cube? Do Department and Site Code map to existing dimensions? What do you mean by the "measure" dimension? (Usually in a GL cub...

Good Morning Everyone, I received a request to create a P&L Report in TM1 for one of my entities. The P&L report was initially created in Excel where is continues to be managed. Each of the six P&L reports are driven by either a Site Code or Department. The challenge that I'm facing is t...

Just closing the loop -

Thank you Steve for the above support. I was able to update my code and get the desired results to fire correctly.

Thank you again,
Michael

In this situation you would add an attribute to use for the mapping. sPeriodToWriteTo = Attrs ('PERIOD MAIN' , vPeriodInSource, 'Mapping Attribute to PERIOD MONTH MAIN'); CellPutN('CubeAInput' ,..... sPeriodToWriteTo.....); If it is just that your source has YTDs at leaf and your destination moveme...

Good Morning Everyone, I have a manual Excel process that retrieves data from Local Cubes, then combines that data with manually-input values and pushes the updated values back into the Local cubes. So, in an attempt to semi-automate the process via TI processes, I built two cubes (let's call them C...

Thank you all for the suggestions. I am just finishing up month-end, but will pivot to development efforts shortly.

I greatly appreciate it!

Michael

Good Morning/Afternoon All, I am in the process of creating a new cube, which will replace one that contains fewer dimensions, etc. Before I make the switch from CUBE123 to CUBE456 I want to ensure that all processes, TI processes, rules, security, etc., have been migrated to the new cube. Is there ...

If you are going to be renaming processes, you may want to consider naming your processes with } prefix to denote system objects. Normal users will not see them unless the explicitly show these and have applicable security. If you are using PAW, there is an option to create system objects now too. ...

Good Afternoon Vovanenok, Thank you for the quick response! It sounds like the path that I took, while painful, is the correct path. I'll run into additional headaches when renaming "Cube A" to "Cube A Historical" and "Cube B" to "Cube A". Though, I wonder if ...

Good Afternoon Everyone, I have an existing cube with a number of views, TI processes, etc., along with the rules file and security settings. I was tasked with adding a dimension to the cube, but in my research it pointed to using a "IBM TM1/CX Planner Applications" Performance Modeler sol...

Good Morning All, Sorry for the double-post. That is exactly what the query was looking for with respect to defining the "Current Year" member as a string value. Here is the final code for reference: {FILTER( {FILTER( { TM1SUBSETALL( [PERIOD MONTH MAIN] )}, [PERIOD MONTH MAIN].[FORECAST MO...

You could try something like this: {FILTER( {FILTER( { TM1SUBSETALL( [PERIOD MONTH MAIN] )}, [PERIOD MONTH MAIN].[FORECAST MONTH] = "FORECAST") }, RIGHT([PERIOD MONTH MAIN].[PERIOD MONTH MAIN].CURRENTMEMBER.NAME,2)=[GLOBAL VARIABLE].([GLOBAL VARIABLE].[Current Year]) )} )} No guarantees -...

Good Morning Everyone, I am in the process of writing an MDX expression that filters my PERIOD MONTH MAIN dimension based on two conditions. The first being where the attribute of FORECAST MONTH contains "FORECAST" and the second condition based on a wildcard search for "22" whic...

Good Morning Everyone, When I looked at the Import Options (see attached) I initially thought it referred to the data type itself as String versus the element when being added to the dimension as either N for leaf (numeric) or C for consolidation. I rolled back my changes to mirror PROD, then went b...