Rules to load data from attribute to element

[Shwetha]

Hi ,

I wanna load data from an attribute in a dimension to measure element in other dimension which belongs to same cube.
Ex: Cube A has dimension x and dimension y
Both dimensions have different set of elements.
I wanna copy data from one of the attribute(say m) from dimension x to measure element (say n) from dimension y.

Please someone help me in writing rules and feeders

[BariAbdul]

This might help:

http://www.tm1forum.com/viewtopic.php?f ... ube#p26382

Thanks

[tomok]

Hi ,

I wanna load data from an attribute in a dimension to measure element in other dimension which belongs to same cube.
Ex: Cube A has dimension x and dimension y
Both dimensions have different set of elements.
I wanna copy data from one of the attribute(say m) from dimension x to measure element (say n) from dimension y.

Please someone help me in writing rules and feeders

Given the lack of details on your part this is as specific as I can be (assuming the attribute is a string):

Code: Select all

['n']=S:ATTRS('x',!x,'m');

The feeder for this would exist in the }ElementAttributes cube and be:

Code: Select all

['m']=>DB('Cube A',!x,'n');

[lotsaram]

The feeder for this would exist in the }ElementAttributes cube and be:

Code: Select all

['m']=>DB('Cube A',!x,'n');

That's cruel Tom.

[tomok]

The feeder for this would exist in the }ElementAttributes cube and be:

Code: Select all

['m']=>DB('Cube A',!x,'n');

That's cruel Tom.

Cruel? For giving him what he asked for or for NOT telling him what he wants to do is a bad idea? If he would have provided a little more information, like why he wanted to copy an attribute into a cube, then I would have pointed that there's really no need to. Just reference the attribute in the report / active form / web sheet. Who cares if it's in the cube as long as it's accessible.

[lotsaram]

I just like the idea of feeding from the attribute cube!

[java_to_tm1]

I would have pointed that there's really no need to. Just reference the attribute in the report / active form / web sheet. Who cares if it's in the cube as long as it's accessible.

If websheets are an option, I would go with DBRA'ing the attribute rather than bringing it into the cube itself.
But I've worked with client's who are so pissed with having to do their planning and Forecasting on MS Excel that they wont open a websheet!

Without Cognos BI integration, the only "reporting" option available is to pull the attr as one of the measures in the "report" cube view.

Love the idea of feeding from the attr cube!

~Sri

[Shwetha]

Hi everyone,

Thank you for the reply. Sorry for my late response. I am new to TM1 and was trying different options to acheive some calculation through TI process.

Thanks,
Shwetha

[danielb]

Just reference the attribute in the report / active form / web sheet.

Hi everyone,
i'm new to tm1 and i have the same problem: i have a dimension with some element attributes and i need to show them in a cube view in tm1web (i'm working with cognos express and xcelerator).
How can i reference the attribute in the tm1web view?
Thanks,
daniel

[declanr]

Just reference the attribute in the report / active form / web sheet.

Hi everyone,
i'm new to tm1 and i have the same problem: i have a dimension with some element attributes and i need to show them in a cube view in tm1web (i'm working with cognos express and xcelerator).
How can i reference the attribute in the tm1web view?
Thanks,
daniel

A cube view can only show exactly what is in the cube. Your options are either to bring the attribute into the cube (likely causing unnecessary duplication) OR don't use a cube view and create an active form that still has all the cube data referenced but with an extra column doing a DBRA.