TM1 Forum

Thank you all for your responses.

I have checked the date validity with the help of Leap Year calculation by Declan.


Cheers

You can just have 1 numeric measure formatted as a date which will only allow valid date entries in your specified format. Or if you MUST have it set via 3 distinct string measures of "Year", "Month" and "Day" then you can use an attribute picklist for Year and Month w...

@tomok, yours is a valid question. I wanted to handle the case when user enters data in a cell beyond end date of the month. Though, the data is entered accidentally, i am checking for options if it can be handled at database insert in the TI process using ODBCOutput.

I have a cube which has 'Days' dimension and 'Month' dimension and some other dimensions too. The Days dimension has elements Day 1 to Day 31. 'Month' dimension has all the 12 month names January to December. In the cube view, While selecting the Month (say June) under 'Month' dimension, I want to r...

I'm pretty sure this is what he is looking for: http://www.tm1forum.com/viewtopic.php?f=3&t=3245 I'm not sure how you got to headings? It sounded to me like he's trying to concatenate text generated from 2 different tabs, which as the link I specified said, you can only do this using a dos comm...

Hi All, I have a written a TI Process which generates data from the Cube and writes to a file using ASCIIOUTPUT. In this TI Process, the text is generated in PROLOG tab and DATA tab. I want all the text to be written into a single file (Prolog tab generated Data and then Data tab generated Data). If...

Thanks Dharav and Paul for the response.

Paul,

To clarify your question ,the requirement is to show the data in sorted order when we drill down a consolidated level without disturbing the nodal order.
The details are in the attachment "Drill down View.docx" in my initial mail.


Cheers

Thanks Declan and Tom.

Hi Declan,

The business requirement is to show the elements with the data in the descending order when we drill down a consolidated level without disturbing the nodal order.

Hi

Can someone throw light on this if we can achieve by Active Form.

Cheers

Thanks Declan for the quick reply.

Is there any other method to achieve the data in the sorted order?

Cheers

Hi I am having a View and the requirement is to sort the data in descending order. I have sorted on CubeViewer and recorded the Expression. The sorted View is as follows: Sorted View.docx The Expression is as follows: Expression.docx Now when i drill down the View/expand 'S Series 2WD', the data bey...

Declan,

Thanks a lot. It is really helpful!

Hi All,

Please provide the steps to be followed to hard-copy/freeze the historic data.
Do we need to make changes to the Business Rules which are calculating for the historic versions made static.

Thanks all for your responses. To answer your questions: I assume you are moving data here with a TI, correct? Translate the currencies on the way in. Yes, the data comes through TI process. I am exploring approach to make historic versions data static so that it will not calculate each time for all...

Hi All, We have a problem in our TM1 system...a Reporting Cube, whose response time is too long i.e close to 4 minutes. This "Report Cube" has 9 dimensions. This cube though sounds only for reporting purpose, it is used for forecasting also. There are many business rules along with some Tr...

Hi kangkc,

Thanks for your response.

We are reviewing the installation setup and the krb5.ini setup file and others.
There seems to be a setup issue as KERBOROS parameter is not setup properly.

Hi kangkc, While logging in to TM1Web 10.2 using "Windows Authentication", I am getting error message "An error has occured" after entering Windows login credentials. I have followed the instructions in the below URL, "Configuring Integrated Security for Cognos TM1 Web 10.2&...