TM1 Forum

Anybody else? I think it's one of the hardest questions in this quiz @MVPs, @Admins, can you share your thoughts also? [‘a’] = [‘b’] + 4; Well this specific case is highly, highly theoretical as I can't imagine any practical use for such a rule in real life. Seem as it is an open rule applying at a...

We have a few PAW books created in PAW and want to open them from PAX. The reports have attributes displaying along with measures. It's a completely different UI. Sure you could recreate a PAW book in Excel with the same content and layout but you would be recreating it. You could have a hyperlink ...

I think the easiest way to solve this (assuming the GUI is PAfE or Perspectives or Apliqo UX) would be to have a helper dimension which encodes valid reporting selections. (This dimension is artificial and just for lookups and isn't in the cube.) The helper dimension would have attributes for Accoun...

It's not possible to answer your question without you first providing more information about the current structure of the GL cube. What are the dimensions of the cube? Do Department and Site Code map to existing dimensions? What do you mean by the "measure" dimension? (Usually in a GL cube...

You are going about this all wrong. Just accept that a element type in TM1 once defined is immutable. However, *news flash* it doesn't matter since you also have aliases. In your hypothetical scenario there is no need to do anything to "1234_A". The element doesn't need to be recreated, th...

Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful No this doesn't exist and never will unless a 3rd party comes up with something. Because PAfE also supports slice reports and active form...

What you are describing honestly makes no sense at all. In the real-world prices change all the time and in any sensibly designed system you do not change product code identifiers for a change in price. The same product may sell for different prices in different channels, or in the same channel in d...

The reason may be a little bogus but it certainly won't lessen the user experience for Modlers/Admins. And bear in mind that PAoC RDP and Arcitect/Perspectives are only available for Modlers not the general user population who have only ever had Workspace and PAfE. From a model building and administ...

Your OS seems a little outdated ... Won't help with your issue but just for clarity: - tm1a.exe is architect - admin server is tm1admsrv.exe (or tm1admsd.exe for the service runner) Are you attempting to use the 32 bit version from bin or the 64 bit version from bin64? There have been issues in the ...

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks. e.g. Union( [dim].[a].children, [dim].[c].children ) This can't work by definition. The hierarchies are separate entities. No C elements are shared. You could use Generate to loop a set on one hierarchy ...

hmmm ... a generic process for exporting TM1 cube data you say ...
https://github.com/cubewise-code/bedroc ... export.pro

Thanks Wim, that's an interesting read, most of the items are pretty obscure. A few items stand out though TI Functions. Interesting that the ASCIIOutput function is not listed, the one thing that has been known for a long while to not be possible. Same for ExecuteCommand. AssignClientPassword - I'...

Data commit (the last step of the process) is single threaded / locking as it updates the cube index structure, so it might be the case when a lot of Tis are committing at the same time and are queuing due to this. It might be better to split data less evenly, so that they're committing at differen...

Hi MarenC, Thank you so much for your reply, but I tried this, this isnt working. And I am writing the rule in product attribute cube only. 2 rules I tried:- 1.) ['at_PBBU'] = S: If( (DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU') @= 'Y') , 'Y' , '' ); 2.) [...

If I am not mistaken, the TI process will generate error if there is command to update the cube. You are mistaken. TI processes always run with DataAdmin rights (full Admin if the "Security Access" option is also selected). Therefore users can update dimension and cubes they don't have th...

zbhmida wrote: ↑Mon Mar 18, 2024 1:24 pm We reordered the dimensions of the target cube (the system proposed a 42% memory gain).

Why would you reorder to a worse dimension order?! When reordering the idea is to REDUCE memory footprint

I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work. The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be di...

It might help if you can explain why you need to do this. Do you need to flatten data and export using the key to another system?

I assume the version in your profile isn't up to date? What version are you on as I am quite sure this has been solved for quite some time.

+100 for George’s 1st post.