TM1 Forum

Thanks Adam, Yes we already have this code in all our processes. bt in few cubes (for views) and in few dimensions (for subsets) we get below mentioned error Reason same as mentioned in main post. Subset/View folder doesnt exists in server but is visible and we are not able to delete that too manual...

Srry I have already cleared the logs (as file size was very big), will check and share if next time I will get the same issue. Yes I am trying to DELETE the }vues Folder while TM1 Server is running I cant even open this PARTICULAR folder as of now, while in other files/folders (under data directory)...

HI All, Need your help in fixing an issue which I am facing very frequently. I do not get able to Create Subset/View, even when I have FULL ADMIN RIGHTS (both in Server and TM1 instance) Upon checking the DATA DIRECTORY, found that subset / View folder doesnt exist there but is visible (Check the sc...

Thanks Everyone for your reply, My actual issue is I have a cube (view screenshot attached below) TM1 Cube View.jpg I have exported the data in a csv file, using following code To remove the duplicates in extracted file I tried to make sure to select All consolidated level data in PROLOG tab, But I ...

Hi All, Need your help I have a source csv file (having few duplicate records), need this file to get processed in TM1 before that I want to remove all duplicates thru a TI process. How Can I achieve this ? My source file having approx 10 columns C1, C2, C3 ...... C10 While checking manually I find ...

Thanks for replying, Yes I have done that only, created a CELL SECURITY cube and have applied following rules, bt getting error while saving the rules Can you check and suggest what is wrong here (error with some parenthesis) [{'1+11','2+10','3+9','4+8','5+7','6+6','7+5','8+4','9+3','10+2','11+1'}, ...

Hi All, Need your help We have a cube where we have ACTUAL scenario - ACTUAL and Forecast Scenarios as - 1+11 /2+10 /3+9 ....... 11+1 1+11 will have Jan as ACTUAL month, and FEB.... DEC as Forecast months 2+10 will have Jan, Feb as ACTUAL months, and Mar.... DEC as Forecast months . . We load ACTUAL...

Yes UNION worked for me......
Created 2 separate expressions then used UNION and it worked.

Thanks to all of u

I have 5 Elements A, B, C, D, E ( all are of level 4-5..... they have hierarchy of their own).... Dimension Name : PRODUCT
C is Child of B

I am looking for an MDX Expression to display A, B, C and all only Leaf level Elements of C

Need Help

Recently I encountered a similar scenario ........ say a dimension name MEASURE A (parent) ----- B (child1) ----- C (child2) A = B -C while exporting the data to csv file for all PRODUCT dimension elements.... I selected the top level of dim MEASURE (ie element A) but the records for the PRODUCT ele...

Suppose we have a servers named - AUSTRALIA (only Aus users can access its objects) and JAPAN (only Japan users can access its objects) Now my question was, Can I create a perspective report in AUSTRALIA server fetching data from JAPAN cubes using DBR/DBRW functions (say sales cube) I mean how Austr...

Hi Guyz need your help/guidance .....

I have a SERVER 1 and SERVER 2 in my PRODUCTION environment......
I want to access/run a report from SERVER 1 (perspective report) which is using data from (say)cube 2 residing in SERVER 2.

Need ur guidance for the same.

--
Thanks

Yes it worked for me bro.... Thanks

Thanks Bro

Hi Guyzzz, Need help I have a Dimension : DIM with say 10 level Hierarchy. Have few elements at level ( say 4,5 or 6 any level except the top and leaf level) : AAA, BBB, CCC, DDD, EEE My requirement is to create a Subset : SUB of Dimension : DIM with all the leaf level elements under these parent el...

Hey Guyzz, need your help and guidance I have updated my TM1 server with the updated certificates. Now the prob is I am not able to login to any of the TM1 server through ARCHITECT, but after updating the Certificate Authority path in perspective and TM1p.ini I can login through perspective. Need He...

Thanks bro ....

"Total of Months" worked for me.
Luckily we dont have any such case (Parent -0 , Child-value)

Yes data source is correct

I have created a view with all leaf level elements.
Measure Dim - Value
Month Dim - Jan .... Dec

This is the code I am using ..... IF ( cFlag > 0 ); ASCIIOUTPUT(cFile, '----------------------', '----------------------', '----------------------', '----------------------', '----------------------', '----------------------', pYear, pScenario, '----------------------', '----------------------', '--...

It was working fine apart from one issue that I am getting duplicate records extracted in ASCII file.
Need help to remove those duplicate values.



Thanks