TM1 Forum

Hello, we are testing Cognos TM1 10 and Cognos BI 10.1. We have a TM1 Cube and try to report on this cube. In Cognos BI a Member Unique Name identifies a member. Sometimes the Member Unique Name has a "^" in it, although the element in TM1 does not have it in the element name. Do you have ...

Hi Duncan, sorry, my mistake. It is as you said, the consolidation sums up the values from the leaf level. So, only one question is open for me: If functions like ConsolidateMin, ConsolidateMax are only officially supported for TI-processes, which other options do I have in the rules editor? Thank a...

Hello, thanks for all your replies. They are very different from ConsolidateChildren. Whereas that works with the direct children the ConsolidatedMin/Max/Avg/Count functions work directly off the leaf data in the same way as normal consolidation. As a result they use the feeder information and perfo...

Hello, I would like to write a rule which gives me: a) the minimum for the consolidation of a dimension b) the value of the last child for the dimension consolidation So I need something like: ['All Elements'] = MIN('All Children'); As stated in the examples, the average is calculated with one measu...

Thanks a lot for all your answers. Steve, I really would like to dive in your approach, but I did not understand everything. Cube 1. Employee costs Cube 2. BU Costs Cube 3. Associate Employees with BUs, i.e. Emp 1 works for BU1 20% and BU2 80% Cube 4. Costs by BU, multiply Cube 1 by Cube 2 and add i...

Hello, I want to build a planning cube with following dimensions: - time - business units( with employees in it consolidated to business centers consolidated to business units) - chart of accounts - measures Now I want to build an excel-sheet where the user (business center manager) can input the co...

Hello, I would like to copy data from one cube to another. When I start the TI-process I would like to set the Year that is beeing copied to the new cube. So the filter for the source_cube for the Year is dynamic. Is there any way to do this? I tried to use MDX for the subset that I can define for t...

Hello, I have a dimension called Region with a hierarchy city, country, continent. Also I have an text attribute called "population". Every city can have an entry from one of the following: "low", "medium" or "high". Is it possible to group by this attribute i...

Hello, I have an account dimension that can change their structure over time (slowly changing dimension). I saw some examples with SCD’s where an employee changes his unit and for every structure change the employee gets another key in front of the name. So for the account dimension it would be some...

Hello Tomok,

thanks a lot for your detailed answer, it helped me a lot!

Regards,

Toto

Hello, for a cube I chose to have the four dimensions: Customer, Year, Facts, Product. One customer in the customer dimension belongs to a special sector. In the analysis some of the questions to answer are: - How much sales revenue per sector? - How much sales revenue per country? Would you create ...

Hello Neil,

thanks a lot for your answer. Does this only work for active forms or for slices as well?

I am using 9.5.1. When I export a slice it is always generated as classic slice. For the row it seems that I have a static list of elements. So here I could not change the order, correct?

Thanks!

Hello, in the documentation I read that if I want to export a cube view to excel in TM1 9.5 with the option slice a classic slice is exported. Dynamic slices are not supported anymore. Does that mean that the parameters "AllowDynamicSlice" in tm1s.cfg and "ClassicSliceMode" in tm...

Hello,

is it possible to change the sort of the elements on different columns and asc/desc?
In Excel I do have the Name SL01FILT wich can be changed to changed the sorting. But how can I do that in TM1Web?

Thanks a lot,

Toto

Additional info: When I use TM1Web without portlets and log out the login-sreen appears. Now when I press the button "login" I would expect to be asked for my password, instead I am automatically logged in again. Is this why my login is still the old one in the C8-portlet? How can I change...

Hello, I have to TM1-portlets in C8 on one page. When I logoff from C8 and login with a different user it seems that one portlet still has the old user. After restarting the TM1-Server and login with the new user everything is fine. Did you experience this as well? What could help here? Thanks a lot...

Hello, I have Dimension, where customers are assigned to agents. One agent has one or more customers assigned to him/her and the customer can only be assigned to one agent. As in the file attached I want to create an excelsheet (will be published to tm1web!) where the agent should be able to click o...

Hello, I want to insert a hyperlink in an excel-sheet that references another excel-sheet in the same file with a specific cell. I did it as described in the web tips and techniques pdf from cognos. When I publish it and open it in tm1web and click on the hyperlink the cursor is on the defined cell ...

Thanks for your replies. The customer wants to have his actual application rebuilt with TM1, and it should be usable without any training.
I will have an excel-report published with TM1Web.

Thanks again,

Toto

Hello, isn't it possible to use the data spreading method "percent change" in a TI-process? I only found CellProportionalSpread as a possible function to use in a TI-process. I want to implement a top-down approach where the user types in a "3" in a cell an for the consolidated s...