compare data between dimension with data file in architect (check index)

[myimyoona]

Hi sir

I need to write code compare data between dimension with data file by ti process
example

-In dimension have data but i need to update attribute in dimension, I must load text file .csv into dimension and data must compare
if have data, compare data and update but data not have must insert to dimension

[TrevorGoss]

It may well be possible to do this without using the .dim data files.

The .dim data files wont tell you must, and I do not see how you can work out attributes from the .dim data file.

There are many TI functions that can help you here, ATTRS and all that.

What excatly is it you need to do, it was somewhat difficult to understand?

Thanks.

Trevor.

[BariAbdul]

I need to write code compare data between dimension with data file by ti process
example

First of all dimension doesn't hold data ,it is metadata.

In dimension have data but i need to update attribute in dimension, I must load text file .csv into dimension and data must compare
if have data, compare data and update but data not have must insert to dimension

It is not clear what exactly you are up to,But There is TI function Dimix to check for the element exists.Please describe in detail with the actual data what you are trying to achieve.

[TrevorGoss]

It is not clear what exactly you are up to,But There is TI function Dimix to check for the element exists.Please describe in detail with the actual data what you are trying to achieve.

Indeed, this sounds like somthing that could be solved with a fairly straight forward TI as the compiled (if thats the right word) data files will be expressed fully in TM1 when TM1 is loaded, which would then allow you to use a TI, the data files are seperated and not always readable.

The only times I have gone into the data files is to change a time of a Chore (GMT bug) or to use a program without the API to go into the .cub files and get all the dimensions, which was not pretty.

[myimyoona]

result must that pic.
sorry for my question.

https://www.img.in.th/image/0g2

[TrevorGoss]

result must that pic.

If possible, do you mind pasting the image in the forum? I cannot view the image at work, because of security.

sorry for my question.

That is quite alright!

Thanks.

Trevor.