Page 1 of 1
Rules to load data from attribute to element
Posted: Fri Sep 20, 2013 12:44 pm
by 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
Re: Rules to load data from attribute to element
Posted: Fri Sep 20, 2013 4:00 pm
by BariAbdul
Re: Rules to load data from attribute to element
Posted: Fri Sep 20, 2013 4:15 pm
by tomok
Shwetha wrote: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):
The feeder for this would exist in the }ElementAttributes cube and be:
Re: Rules to load data from attribute to element
Posted: Fri Sep 20, 2013 5:30 pm
by lotsaram
tomok wrote:The feeder for this would exist in the }ElementAttributes cube and be:
That's cruel Tom.
Re: Rules to load data from attribute to element
Posted: Fri Sep 20, 2013 8:04 pm
by tomok
lotsaram wrote:tomok wrote:The feeder for this would exist in the }ElementAttributes cube and be:
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.
Re: Rules to load data from attribute to element
Posted: Sat Sep 21, 2013 7:22 am
by lotsaram
I just like the idea of feeding from the attribute cube!
Re: Rules to load data from attribute to element
Posted: Tue Sep 24, 2013 9:35 pm
by java_to_tm1
tomok wrote: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
Re: Rules to load data from attribute to element
Posted: Thu Oct 31, 2013 9:34 am
by 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
Re: Rules to load data from attribute to element
Posted: Fri Apr 11, 2014 8:16 am
by danielb
tomok wrote: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
Re: Rules to load data from attribute to element
Posted: Fri Apr 11, 2014 10:23 am
by declanr
danielb wrote:tomok wrote: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.