TM1 Forum

Hi I have some vba code running in v9.4 and this works fine using the TM1 api and some code to call a TI process. (Running Excel 2002) However when using 9.5.2 and Excel 2003 the code errors saying cannot connect to Server. Does anyone know of any issues why this should be the case Thanks Carl

At the moment I am returning a subset based on MDX and using the following code to popluate a spreadsheet. strService = "harmony dev:" strCube = "HR Employee List Oracle" strCostCentre = "Total Group" strServCube = strService & strCube strHR_Location = "All Ora...

Thanks guys for the info. The underscore was a mistype in the post. I didn't know that the DTYPE would resolve correctly, so a huge thanks for pointing that out. On another note - do you know who was the author of the TI provided? The code and style of writing looks very similar to a consultant I wo...

I am trying to use a TI process to copy a dimension and all it's associated attributes. I cannot find a TI function to return the attribute type (text, numeric or alias). When I tried to use DTYPE ( DimName, ElName ) on the }Element_Attributes dimension, I noticed that all the elements (attributes) ...

Elements can be renamed in TM1. 1. Create a new alias of the dimension. ie 'NewAlias' (The default names for this new alias will be the same name as the element name.) 2. Edit the alias names for the elements you wish to rename. 3. User the code SwapAliasWithPrincipalName(Dimension,'NewAlias',0); in...