TM1 Forum

Hi All,

We are creating a dimension from data base Table.

I am using ODBC as a Data Source, Query is written and it is pulling 500+ records.
Earlier dimension was getting created properly with out any concerns.

Now we are getting more number elements than required.
When I generate output file, I am getting required details.
But, respective Dimension have more number of elements with in it.

Any idea, what could be reason for having additional elements, rather than what is achieved by query written in ODBC?

Regards,
Deepak Jain

Hi Deepak,

Can you post some code and some screenshots that show your issue? Not sure if it's the code, or might be that Subset Editor is showing the same elements more than once.

Martin

Hi Martin,

I had a look into database table, there is a change in table because of which I am getting unexpected result.
Thanks for your msg.

Regards,
Deepak Jain