TM1 Forum

Got a new idea how to create the view and want to know your opinion. Imagine that via a rule, i create a total year by adding Jan + Feb + Mar +... Then in the view I skip consolidation and not rule (of course). Do you think it can be faster? I've few hope in this solution but maybe, some of you have...

David, you right. Doing this way you avoid to lost some data. But we do not want user to face export fail because some product/client/... does not exist anymore in the datawarehouse. especially the day when they had to export budget for the group consolidation. We prefer to anticipate and force them...

Did you remember to enable super-lickity-split mode? Tomok, What do you means by super-lickity-split mode? I did not found anything about that. Maybe my english is not so good to understand subtlety. lotsaram, thank for your suggestion. The way you indicate was the way we had before with the last H...

Hi David, thank for your help. The idea is not to export data from one 9.4 cube to integrate it in the 10.1.1 cube. The idea is to export data in txt file then , after updating dimension, hightlight data that have been lost. I speak about version 10.1.1 (has we are currently migrating from 9.4 to 10...

To add detail on how the view is created, I have for all other dimension than time dimension the following code SubsetDestroy('ACCOUNT', 'z_Export_Entry'); SubsetCreate('ACCOUNT', 'z_Export_Entry'); Nb_ACCOUNT = DimSiz('ACCOUNT'); i=1; While (i <= Nb_ACCOUNT); ACCOUNT = dimnm('ACCOUNT',i); if (ellev...

tomok, all other dimensions subset contain leaf level elements. Only time dimension selection contain consolidated elements. I've another question. Do you think that divide view in 2 (one for actual data and one for budget data) then create process with a cmd function that agregate the 2 generated f...

Thanks tomok, I will check the state of RAM after the process in order to see if the paging file is use. To justify the 2 settings which export consolidated and rules i would say that the view is base on "total year" which is consolidation of month. Then in the data tab, I export on one ro...

Thanks for your answer. Excuse me to gave you so few detail but I would have a general idea. I'm not able to give the number of row but the size of the exported file is 2.3 Go It take around 1 hour to do the export The setup for the view is the following one (some data come from other cube through r...

Hi everyone, I'm currently working on TM1 9.4 and will migrate to 10.1.1 As I've an export process that take time (lot of time) I would like to reduce it. I use asciioutput function base on a cube view. I would like to know if it exist best practise in using this function in version 9.4 or in versio...

Hi everyone,

thanks a lot for all of your reply. I'm also convinced that Cognos BI will ever be more integrated with TM1 than Microstrategy. How ever, from your point of view, is Cognos BI is user friendly or does it require IT knowledge. Also, same question for Microstrategy.

Rgrds.
Benoît.

Hi everyone, I'm currently searching reporting tools to be used on TM1. I've heard that Cognos BI and Microstrategy could be good solutions but not really reach to have a clear view (especially on compatibility). My mains requirements are to be able to broadcast report by e-mail (I think that both a...

Hi Damientaylorcreata,

I'm facing the same objective today and would like to know if you get answer to your question. if yes what have you implement?

Thanks.
Benoît.