TM1 Forum

Thanks for the quick reply Tom!

While deleting obsolete objects, we have accidentally deleted a dimension which has caused the issue.

Hi Team,

I had to restart my server to update dimensional changes. After server restart i am unable to see an existing cube.
I can view the .cub file in data folder but cube doesn't appear, however i can view the cube name in cubes dimension.
Could you please suggest what might have gone wrong.

Hi All, I am trying to convert my subsets to consolidation nodes in dimension and maintain in a alternate hierarchy. The problem here is if any of the subsets including top most hierarchy node it is breaking the hierarchy structure in dimension. Is there a way to skip a subset with top most hierarch...

Thank You all for your help!! i was able to get the count of elements under a particular hierarchy

I would like to get count of all the elements under a hierarchy. Based on below example country hierarchy should return element count(Clevel & Nlevel) 8. Country - Hierarchy - A - C level A1 - N level A2 - N level -B - C level B1 - N level 1 - Leaf Level 2 - Leaf Level 3 - Leaf Level i am actual...

Hi All,

Is there a way to get the sum of elements under a hierarchy. I used ELEMENTCOUNT function but it is not working.

Hi All, I have an issue when trying to create a new hierachy with subset elements. Subset name would be new hierachy name and all its elements should be rolled up to the hierarchy. Issue is with consolidated elements being duplicated in hierarchy. Hierarchy should hold only consolidated elements of ...

Hi All,

Do we have any option to connect SAP Data Services to TM1 system. Please advise.

@Lotsa,

You are right, 'Similar to' means 'same as' . Issue was with one of the element in Subset and its name being same. DBRW formula was fetching data only for element with subset name.

Issue was with Subset name. Subset name was similar to one of the element in dimension due to which it didn't fetch data for rest of the elements. After changing subset name issue got resolved

Hi Wim, Thanks for your reply, It is a public subset and there are no consolidated rules in cube for that specific intersection. When i use only one company code in DBRW i am able to retrieve data. when i use subset which is combination of 5 company codes it displays value 0. This is behavior is obs...

Hi All, I am unable to retrieve data using DBRW in perspectives, I am using subset in my DBRW formula. It works fine in all the versions except for one version. Formula works fine when i use individual element from company dimension where as it is not working for subset with multiple CC's from the d...

Thank you All for the detailed explanation!

Hi All,

Can we add a new element to measure dimension without data loss in cube. Since the cube is dependent to many other cubes via rules.

Yeah you are right source table is from HANA. It happened only for one run. In the next run it got executed normally

Hi All,

I am unable to kill a process from TM1 TOP, Usually it takes 20 mins to execute. It is running for more than 4 hours. It connects to SAP system and pulls data to TM1.

Thanks,
AR

Hi Alan,

Thanks for the Help!

Somehow Admin host details was missing in perspectives. Went to options and added admin host details and was able to connect to TM1 server.

Hello All,

The issue is observed when we try to connect from TM1 excel add-in for all admin and non-admin users.

Hello All,

I am unable to connect to TM1 server from perspectives as a non-admin user. It is showing error as cannot connect to Tm1 admin server.
i was able to connect to TM1 server when i logged in as admin user.

can i know what is causing this issue.