TM1 Forum

Hi Ty, Thanks for the reply and apologies for the delay in getting back to you. I have missed a part of the code in my copy of the TI Script: vFunctionUnmapped='Unmapped'; IF(ATTRS(vCC,vCCElements,vAttribute)@=''); CellPutN( nValue, tCube, pVersion, vPeriod, vYear, vArea, vCC, vFunctionUnmapped , vG...

Hi Maren, Thank you for the response. Your advice worked and my process now works - thank you again! The majority of work i have been doing in the past with TI's has been cube to cube data transfers where there has never been a reason to use attribute references or anything similar... so thank you f...

Hi Pavo, Thanks for the reply. I have actually have 10 dims in my source cube and 11 in my target cube - apologies! vValue holds the physical value. Here is a extract of the variables i am creating in the prolog: #=========================================================== # Set Variables #=========...

Hi all, I am in the process of building out a TI Process to transfer data from one cube to another. The source cube has 9 dims and the target has 10 dims. The 9 dims are the same across both cubes, with the additional dimension requiring mapping in the TI Process - the sub function dimension I have ...

Hi Wim, Thank you for this. It really helped me to understand more about using picklist control cubes. I've wrote this rule for one of my picklists: ['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function'...

Hi, I was wondering if it is feasible to have a dynamic picklist selection based on another picklist cell. For example, if we have a picklist that has x / y / z and another picklist containing a / b / c / d / e. I'm looking to form a relationship between the two as follows: IF Picklist 1 is X then p...

I've found a solution for my PAfE report, but doesn't enable me to bring the PafE report into PAW. Using TM1ELLIST in collaboration with a MDX statement to make the subset dynamic. Is anyone aware of a function that can be used with PAW to achieve a similar objective to TM1ELLIST?

Thanks for answering my question @ascheevel, very helpful and exactly the solution i'm looking for - great! @Lotsaram, to answer your question and i am building a mechanism that will hold mappings that will be exported from TM1 to a BI reporting solution. My issue is that the mappings table is entir...

Hi, I was wondering if it is possible to design a TI Process to take two dimensions elements and concatenate them together to form a unique identifier in a new dimension that i could setup as a chore? Ideally i would like to do this using incremental loads, rather than clearing out the new UID dimen...