TM1 Forum

Hi all, sorry if I didn't give more details about it but I have good news!! I was finally able to make the rule work, actually it was correct from the start but for some reason the result was always 0.. so i decided to write it from scratch and it worked. I'm giving more details for future reference...

Hi All, Yes, In the first dimension I already created a virtual hierarchy so I can roll up the number at category level. Please see screens below https://i.ibb.co/hB9hSnF/Capture.jpg https://i.ibb.co/3ph2CCw/Capture.jpg So i can see the values in cube 1, and in dimensions 2 i have those codes.. I kn...

Hi all, I need to retrieve values from a cube using virtual hierarchies, but i'm struggling to write the DB function. What I have is as below: https://i.ibb.co/C9WGB7j/Capture.jpg I want to get data from cube 1 to cube 2. And i need to use the virtual hierarchy i created in the dimension Products Ac...

@mrdauduong you said that your friends are able to synchronize the dimensions in a published pax exploration report?

I tried in every possible way but nothing.
I even added the SUBNM formulas in the same websheet of the exploration view and in paw the synchronization is enabled

Hi, Thank you for all your comments! The dynamic quick report seems pretty cool! But I can't rely on that for the moment. During these days I did more tests and I came with this solution that is indeed what you are proposing: Publish a websheet in exploration view, and the view has specific MDX subs...

Hi all, I need to create some reports but I can't find the right way to do them, because every option ha something missing for my purpose. I hope that maybe you could have some advice :) What I need to do is to create a report with these considerations: - The report has virtual hierarchies - The row...

Hi Maren, The "random" view, is a standard view that I create when I build the cube, it's a general view. But often the TI requires a smaller portion of the cube, i keep the leaves only and more importantly there are parameters (for example the year), this is why i define a new view in the...

Hi, this is what I usually do: in data Source: I select a random view of the cube that I want to take the data from in prolog: I build a temporary view + temp subsets and replace the old view with the global variable DatasourceCubeview in metadata/data: now I have the right set of data to complete m...

Hi, I'm creating a TI process to copy data from one cube to another, but in the data section the variables are assigned with a different order. For example, I have these two dimensions: Products - Product 1 - Product 2 - product 3 Warehouse - Wh 1 - Wh 2 - Wh 3 But when I move to the data section, v...

Hi everyone, I recently switched a TM1 server from securitymode from 1 to 5 The problem is that I have TM1 groups created previously and I can still see them in the ClientGroups cube, however, these groups are not seen anymore in my TM1 applications except Cognos/Everyone If i'm not mistaken, with s...

Hi!

Thank you for your reply.

Indeed I have a nightly chore that cleans the logs older than 2 weeks.. I completely forgot about that.
I will increase it to one month so everything should go fine.

Thanks!

Andrea

Hi everyone, Sorry but I couldn't find another post related to this. I've been asked by a client to increase the transaction log duration. At the moment it seems that it keeps track for the last 2 weeks and I need to increase it to 30 days. Is it possible to change it? If Yes, do you know which para...

Hi everyone, I'm currently developing a TM1 application for a client and they would like to use an application without having multiple users write at the same time. I'm therefore creating a central application because I don't need any approval hierarchy, but I can't make the ownership work properly....