TM1 Forum

Thank a lot Lotsaram!!

I was able to retrieve the names , attributes by specifying it in tuple members. This has fixed my issue

Hi Maren, Thanks for the response, Yes attribute is a alias. I can turn it on works fine in TM1. I am actually trying to read view via REST API which only pulls native elements though i save my view with Alias turned on in the view. Looking for an option to turn on alias within MDX expression.. Than...

Hi All, I am using a MDX expression to pull current year from a lookup cube in subset. The values retrieved are native elements and are in fiscal year format, Quarter dimension has a calendar year attribute(CY Year) to display elements in CY format. Tried to use CurrentMember.Properties function but...

Hi all, I'm trying to retrieve cube a view using the REST API. I want to retrieve data similar to architect view with alias turned on in few dimensions, API retrieves only native elements. Is there a way to retrieve attribute names in cellset, For example Quarter dimension retrieves native elements ...

Thanks a lot Tom,

I have exported my cube data successfully to my target file with headers

Thanks,
Arvind

Thanks a lot Tom, Got to know like how the intersection of nodes at element level works. If i get the values by using CellGetS/CellGetN and export using ASCIIOUTPUT i will be exporting the values, Will i be able to export the Measure Element as column header holding its values?? correct me if i am w...

Thanks Wim, Thanks David,

I have created an Application which uses my cube views and i have created a websheet with action button which calls the TI process and deployed the application. It worked well.

Thank You All Guys

Thanks,
Arvind

Wim, Thanks for the reply, i have gone through the other topic about ASCIIOUTPUT, but that wont fit my requirement. The issue is in my case my measure dimension has elements of both String and numeric one's. Current Ouput in CSV: Column A Column B Measure Element1 RUSSPRO Measure Element2 6/4/2012 M...

Hi Guys, I am trying to export data from cube as "CSV" target file using TI process, I was sucessfully able to generate the target "CSV" file. I have two issues in this task. 1. I am unable to copy the target "CSV" file in to specified location, It is displaying an erro...

Thanks for the reply Wim, Can we deploy the TI Process in to TM1 Web?? I have a requirement where i need to Execute TI process from TM1 Web.

Thanks,
Arvind

Hi Guys, I have a requirement where i have to access my Control Cubes and TI Process from performance modeler in TM1 web. I should get access to Cube/Cube Views so that i can input my values in to cube. After i fill in the input values into my control cubes i have to execute my TI process, once it i...

Thanks for the reply nybble, I have created "Ragged Hierarchy" using Guided Import but could not meet my requirement. Could do u guide me like where to create these "Filler" elements.

Thanks in Advance,
Aravind

Steve,

Thanks for the reply, Pls find the attached TI Code

Hi Guys, I am trying to create a ragged hierarchy using performance modeler TI Process.My datasource is a file. i have multiple columns in the source file, there is a column named "Sub Parent Name" which has values and blank values in it. The succeding elements of "Sub Parent Name&quo...

Wim,

I have commented the Feedstrings statement in the rule editor and executed the TIP but there is no performance Improvement!!

Hi PavoGa, we are loading both numeric and string data in to the cube, you want me comment the code in prolog tab and copy the same in the epilog?? Wim , there is Feedstrings statement added at the top of the rules statements, You want me comment that??? Brain, ForceReevaluationOfFeedersForFedCellsO...

Steve there is no MDX subsets. As Tom said i guess the problem would be due to feeders the reason being there auto-generated feeders by performance modeler. The model is link driven, The cube has 5 target links.

Thanks,
Aravind

Hi lotsa, It is an actuals load TI Process which copies data from CSV file to cube. It has two dimensions "Item" and "Item Attributes" the "Item Attributes" dimension has 7 elements out of which two of the element's has attributes which uses "Subset Picklist",...

Hi Team, I have a simple Turbointegrator Process with 2 dimensions in it, the datasource is CSV file. It has around 600 records but it taking around 23 minutes to execute. Here in one dimension two of its elements are populated by "Subset Picklist". Please suggest me to optimize the execut...

Thanks for the reply tom. Yeah u are right, the issue is not with the mapping it is with the data type of the target element. Issue got fixed