T.I. script question

[mags88]

Hi All,

I wish to update a Cube using data from a .CSV file via a T.I. process. The problem is is that I have two different sets of hierarchies.

The dimension in the cube has a set of hierarchy ( Rail (Group) -> Rail, x train, y train )
Rail, x train and y train are child elements of Rail (Group).

The data in the .CSV has a another set of hierarchy ( Rail -> x train, y train )
x train and y train are child elements of Rail.

When you run the T.I., the T.I. loads the data associated to x train and y train but it puts x train and y train as child elements of Rail.

Question: Is there a piece of T.I. script I could add to the T.I. process that would stop x train and y train being made child elements of Rail in the cube?
Some sort of script that would stop x train and y train being made into child elements but still loads the data for those elements.

One solution is to make the .CSV file have the same format as the cube (i.e. in the .CSV file the parent element would be called Rail (Group) and not Rail like it is in the cube). Is there another way though?

Regards,
Magnus

[Wim Gielis]

Hello there

If I understand correctly what you mean, I think that you should just put no code in the Advanced > Metadata tab of the TI process.

If you are scripting the process, you can simply leave that tab empty.
If you use the wizard to "record" the code, use "As is" in the Maps > Dimensions tab. Then, dimension elements elements are not created. In the Maps > Consolidations tab, do not specify parent-child relationships.

Or do you mean something different?

Wim

[mags88]

Hi,

Thanks for your advice and yes I think you understand my problem. Just going to try out what you said.

Regards,
Magnus