TM1 Forum

Hi, I'm started testing PAW on Linux. Currently using version 2.0.39. I want to test and do the backup of the content before to upgrade to 2.0.41 but script backup.sh not working. In logs returning me this message in mongo folder: failed: error connecting to db server: no reachable servers I'm using...

Hi Guys,

Thanks for advice will use it and change the process.

Kind Regards

Rafal

Hi All, I need to copy and do calculation for budget data. The problem is that budget information is stored on 1 day in month (daily time dimension). Example of hierarchy below: Sep 14 2014-09-01 (data is stored in this element copied in rules from monthly cube) 2014-09-02 (all other elements in Sep...

Hi Will,

I don't know why but I haven't done it. After proper formatting it's working fine.

Many thanks for your suggestion. Sometimes simple thinks are hard to resolve

Regards

Rafal

HI All, I'm working on 10.1.1 Cognos Express version with FP1 installed. I have some issue with report which using Active Form. Excel version working without any problem. When I open this report on TM1 Web it's looks fine but after refresh it using Active Button (with Rebuild Sheet option) I'm losin...

Hi,

Thanks guys for yours help. I've used }HierarchyProperties to define default members and levels.

Regards

Rafal

Hi All, We using in company Cognos Express 10.1.1 version. For now we using TM1 and reporting using excel. I was asked to used some TM1 cube and rebuild one report for mobile customers in Report Studio (Active Report). I've done some training from IBM and practise on samples but in real data I have ...

Hi Gabor,

Many thanks for your help.

Regards

Rafal

Hi, I fixed the issue this code below working : sDimName = 'DestCustomer'; nX = 1; nLimit = DIMSIZ(sDimName); WHILE(nX<=nLimit); sElementName = DIMNM(sDimName,nX); sConElement = DTYPE(sDimName,sElementName); sNumberOfChildren = ELCOMPN(sDimName,sElementName); IF (sConElement @='C'); IF(sNumberOfChil...

Hi, I'm trying to remove all consolidations elements without any children from dimension. This code below not working properly because deleting only some elements. What is wrong in this code below?? In this dimension I have multiple hierarchy. Thanks for any suggestion. sDimName = 'DestCustomer'; nX...

Hi Robin,

Thanks for info I'll try to run this overnight and will look if this will delete all not necessary elements.

Regards

Rafal

Hi,

Gabor's code working but for small test dimension. I created test dimensions and it's working correctly I only have a problem with big customer dimension (it has about 600000 elements there).

I'm doing this test on test server.

Any suggestion?

Many thanks

Hi declanr, But in this example I'm not deleting elements from source dimension. I'm checking index in source dimension and checking if this element exist in destination dimension and if is deleting it. I don't think if I reverse the loop that will fix this problem. How the code should look like fro...

Hi,

Thanks Gabor for respond, How long this process should run? I'm waiting about 15 minutes and server not responding. The source dim has about 600000 elements that's maybe the reason?

Any other suggestion??

Many thanks

Hi All, I have some problem with some TI process. I want to delete elements from customers dimension which not have any idea in cubes where this dimension 'Customer' is using. I prepared processes which looking in each single cube and copied preparing temp cube. After this operation I have two dimen...