TM1 Forum

Hi Everyone, I’ve got a ti that updates a dimension with sql table as data source. So I got a parameter used to filter the dimension name in sql. If user has a typo in parameter (that means spelling doesn’t match the one in sql), then I wanna generate an error in the log & quit the ti because sq...

Thank you all for your contributions. I appreciate it.

Should we be running DimensionSortOrder in metadata? Isn't it better to wait until the process finish scanning all the records in sql then call the function in epilog? I've got DimensionElementInsertDirect in Metadata section, does anyone see a conflict between this 'direct' function and 'sort' func...

Hi ALL, Has anyone encountered any issue when doing DimensionSortOrder( 'dimname', 'ByInput', 'ascending', 'ByHierarchy', 'Ascending') in Epilog? I ran a simple TI that updates a dimension elements & consolidated ones with the Oracle SQL as data source. It would run fine without the DimensionSor...

So does that mean it doesn't matter which one to use if we're in metadata or prolog tab?
It'll only make a difference when using it in Data tab?

Hi Everyone,
What's the difference between DimensionElementDeleteDIRECT and DimensionElementDelete ?
Is one better than the other?
Thank you.

Thanks Alan. You've been helpful.

Hi Everyone, How do you make sure that whoever runs the TI Process does not enter a decimal value in the parameter prompt in tm1 ? What I’m thinking is doing a check in Prolog, using iF statement. I’d like to do ProcessQuit if user types in a decimal value. But I can’t think of a function that detec...

I need to get a list of all elements & its attributes from each dimension, then put them all in a cube with the following layout: DIMENSION NAME ELEMENT Type HTE_DESC HTE_CD WID_Loc WID_LOC_NM Loc_Seller FTN Simple LOCAL 02 134501 Market China Loc_Seller USB Simple China 03 17453 Market Africa L...

Hi all,
Is it possible to get all elements in each dimension and put them in one dimension?
If so, how to do it?

Hi Everyone,
If I wanna get a list of dimensions with no cube using it, do you think it’s possible to write a process to get the list?
If so, how can we do this?

Does anyone know which process updates this cube }ElementAttributes_}Dimensions ?

Hi everyone,
I see cubes }ElementAttributes_DimensionName created for each Dimension in our tm1.
Do you know which process creates each of these cubes ?

There's gotta be a way to write a ti process to automate the whole procedure and store it in a cube, right?

Hi Everyone,
I need to get a list of all elements & its attributes in each dimension, and put them all in a table (Excel).
How can I do this?

lee

Thank you all for the reply.

Thanks Declanr.

Hi Everyone,
Can we add a dimension to an existing cube? If not, why can't we do so?

Hi Everyone, One of the sql table fields to be used as dimension has null value in it. I doubt we can create a 'null' element for the dimension. If that's the case, I can't really do cellputs or cellputn to insert the data into an intersection with null element, right? For example, if I do CellPutN(...