TM1 Forum

Good Day Everyone, Apologies if I am asking a basic question. I may be trying to accomplish something that is not possible. I have a dimension with multiple consolidated level, Dimension Structure -OTHER -Project -account -Other account The OTHER level is the top level followed by a project, account...

Thanks for responding , Actually I request an assistance with feeding this rule

Yes , MDA TRIAL BALANCE is different cube.

Good day All, I am having a challenge with the following rule ['Opening Balance'] = If((ATTRS('Calendar',!Calendar , 'IsMonthApril')@='Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags')@='Y') ,0,DB('MDA Trial Balance ',!Calendar,!Version,!Data Source,!Client,!Property Sector,!Property Grade,!P...

Hi Declan.

This works fine.

Thanks again.

Hi Declan.

Thanks a lot.

Will look into it.

Much appreciated.

Hi.

Is there anyway to filter by the Status for Tm1 Scorecarding?

For example, on PAW, is there anyway that I can select the excellent status and have it display only the records with an excellent status?

This must work dynamically like a normal filter.

Thank you.

Hi guys, The problem lies with one of our processes which we were executing. We have managed to optimize the process to run in a much efficient way possible. We are working with a huge amount of data, so by executing a process which works a large amount of data, it tends to slow down the server resp...

Hi guys, With regards to the Tm1 Server, I've been experiencing issues as of late. Once the Tm1 server has been restarted, it runs fine for a while in which we can submit, approve, and reject. However, when we open the Dashboards on PAW, it doesn't tend to load, in which the application also stops r...

Hi guys, On our current system, we have the following hierarchy: Cluster -> Department -> Branch -> Business Unit Users of business units will submit their budgets to a higher level (branch level) We currently require the following functionality: Is there any way for the system to compile a report o...

Hi guys. I’m not quite sure if the following task is achievable, but kindly take a look at it. Can a Tm1 Cube become updated only after the specific element data is approved? Currently, we are working on an approval application, where our hierarchy states as follows: - Cluster - Department - Branch ...

Hi guys. We are currently working with an approval hierarchy application type on Tm1/Planning Analytics. Our hierarchy structure is as follows: Cluster -> Department -> Branch -> Business Unit. The user at a Business Unit level will submit to the Branch level. Is there any way to retrieve a list of ...

Hi guys. On a Tm1 Application, I would like to know if it's possible to hide elements based on a specific time period? Refer to the following scenario: The business contains a specific budget period. For that budget period, there are four quarters. Based on your current period (system date-time), ca...

Hi guys. On a Tm1 Application, there is a requirement in our business which states that the manager must be notified on a certain date which budgets haven't been submitted. We are using an Approval Hierarchy application type, and our current business structure/hierarchy is as follows: -> Cluster (Hi...

Hi guys. Currently we are working with an hierarchy of four levels: Cluster -> Department -> Branch -> Business Unit Cluster is our highest level, whilst Business Unit is our lowest level. Currently, we are using the Cognos Applications Portal to Capture the budget, and Planning Analytics Workspace ...

Hi guys, On a Tm1 Application, is it possible for me to insert a dialog/message box to restrict the user from entering a value over or below a specific range. Functionalities which we require: - As stated above, there should be a dialog/message box to restrict the user from entering a value over or ...

Hi Tom.

We are using Planning Analytics Workspace.

Hi guys. We currently have four levels in our hierarchy which is the following: 1. Cluster 2. Department 3. Branch 4. Business Unit Cluster is our highest level, and Business Unit is our lowest level. Our charts are created on the highest level(Cluster) whereby the user who is viewing the Cluster ca...

Hi guys I'm new to Tm1, and I would kindly ask for an explanation for the following rules: Part A [{'Budget Year 2019/20','Budget Year 2017/18','Budget Year 2018/19'}] =S: IF( (ATTRS('RE ObjectAccounts',Dimnm('RE ObjectAccounts',Dimix('RE ObjectAccounts',!RE ObjectAccounts)),'MappedBU') @= ATTRS('RE...

Hi Tom.

Thanks a lot Sir.

Much appreciated.

Hi guys. I have an Hierarchy consisting of 4 levels. Cluster -> Department -> Branch -> Business Unit. Cluster is my highest level and Business Unit is my lowest level. In IBM PAW or Performance Modeler, is there any way to hide my lowest level, so that it doesn't allow me to drill down to this leve...