TM1 Forum

Hi All, I need to build a hierarchy dimension from Element Attributes cube, the hierarchy is as shown below; Basically the situation is this. I am updating a dimension with multiple unbalanced hierarchies. So I started by setting up attributes for every hierarchy that contain the current parent. Lev...

Hi Tomok,

Its just a Lookup cube ...

1 rule statement Populating the Concatenation of Geo+ Entity code for A&B Cells
2. Checking if that value exist in the Report dimension ...if exists say 'Yes' or 'No' for C

Thanks in Advance

Hi, I am a newbie...not sure what feeders i need to write. ['A','B','Current Version']=S: IF(Dimix('Entity', ATTRS('Geography',!Geography, 'MC')|ATTRS('Entity', !Entity, 'Code')) =0, STET, ATTRS('Geography',!Geograph, 'MC')|ATTRS('Entity', !Entity, 'Code')); ['C', 'Current Version'] = S: IF(DIMIX('E...

I have tried now with 0 ...even then its not copying the rule derived cells or exporting the values for rule driven cells.

Do, i need to have a feeder for these rules...If so what feeder statements do i need to have?

Thanks for the immediate response and for your time.

Hi All, When i am trying to copy the data from one version to another using TI Process ...I am able to copy data only for input cells but not for derived cells. I have defined the VIEWEXTRACTSKIPRULEVALUESSET =1 and CellIsUpdateable(Cube, e1, e2 [,...en]) in the TI but still i could not copy or expo...

Thank You! Duncan, Wim and qml

now,i was able to resolve it.

Thank you! Wim and qml for the quick response. Now, I am facing invalid string element expression issue. [ 'Target'] = S:IF(['source'] @ =' ', !dim1,STET); here ['target'] is having s elements and !dim1 has n elements. But the !dim1 has 'n' elements throwing error has invalid string elements express...

Hi Everyone, I am working on a rule ...the purpose of this rule is to populate values for target (s) element ...when blank or no value is found for Source with elements in !dim1. I think we cant use direct !dim1 to populate elements...is there any way to populate elements? [ 'Target'] = S:IF(['sourc...

Its okay...even if can populate the value by concatention of Attr from dim1 + attr from dim2 without referring dim4.

Thanks in Advance.

Here is the rule i am trying:

['value'] = S: IF (ATTRS('Geo', !Geo, 'Geo_code') @ = SUBST(!Dim4, 1,4) & ATTRS('Entity, !Entity, 'Entity_code') @ = SUBST(!Dim4, 5, 9), ! Dim4, CONTINUE);

But getting error...Might be syntax wrong.

Thank You! Msidat

Hi Everyone, I am trying to Populate the mapping value from Dim 4 to the mapping cube. Here are the information for the mapping cube and dimensions. Mapping cube has Geo, Entity and Mapping value dimensions. 1. Geo dim has Geo_Code attribute 2. Entity dim has Entity_Code attribute. 3. Mapping value ...