TM1 Forum

Works. thanks.

Dear All, Tm1 10.1 Tm1 web I need to solution for TM1WEB to check if a subset exists for a Dimension. I like to set a default subset for a SUBNM based on the outcome of a check. The name of the subset is concatenated based on some excel cells. Here an example: Cell A1: Spain Cell A2: ProductsA Cell ...

Logging was setup for some non-planning cubes and probably in some processes we didn't deactivate the logging. Has already been changed.

Hello Everyone, we move all night the content of our Logging folder into a backup folder. Now I like to check the transactional logging for the last 5 days. So I copied the transactional logging files into the productive Logfile folder of the application and tried to run the transactional logging vi...

@Tomok export and import is already pretty tough because there are about 20 subprocesses I had to change. But if I understood TableManagerOne correctly I can just define a string called "blockMe" in the CopyProcessForAllCubes (this one calls all the subprocesses). So this String is the sam...

Dear All, TM1 10.1 fixpack 2 ParallelInteraction=T Im having a copy process which I like to schedule as chore. The process copies over data from one slice to another for almost all of the cubes in my TM1 application by country. Data tab: ExecuteProcess( CopyProcessForAllCubes, vCountry); If I execut...

Dear All, since we upgraded our Tm1 application now to 10.1.1 (fixpack 1) we are facing some issues in TM1web when executing processes. We have implemented a functionality to copy over the data from one slice to another including a clear process (view zero out). This happens for a bunch of cubes. Th...

Thanks for your answer. The issue only appears in web. In Perspectives everything works like expected. I tested the functionality always unhidden. So it can't be related to that. I saved the sheet now when I was not connected to any server but this also didn't change anything.

Dear all, there is a strange behavior in TM1 web 10.1 in comparison with 9.5.2. We are running 3 tm1 services on one machine (tm1 version 9.5.2). Let's call the tm1 services tm1_a, tm1_b and tm1_c. Our users access the application all via web. To prevent always to change the Tm1 service name in the ...

My guess is you should be using STET instead of CONTINUE. That will cause a consolidated cell to revert to the same behaviour it would have if there was no rule attached. Your are right. Makes sense. I thought somehow that this will prevent the n-level from beeing calculated. But STET only applies ...

Hello Everyone, I like to implement a rule which is generally calculated on all levels (N and C) of the dimension in the same way with the exception that for specific dimensions I like to just sum up the data in the normal way. Solution for this could be to use CONTINUE to skip the normal calculatio...

Hi All, I have to create a subset which shows my product dimension hierarchy in a alphabetic order. The product dimenions looks basically like this: total -c --ad --cf --bd -a --ed --af My subset has to reflect the hierarchy but in a alphabetical order in each level. Like this.... total -a --af --ed...

Dear All, my question is how "overfeeding" is defined. My understanding of overfeeding was that I feed more more cells than needed the aggregation. So there is an overhead on fed cells. Now I had an discussion with another developer who told me that a cell could also be overfed if the cell...

Hello everyone, I like to tricker the security settings for an element of a dimension in parameter cube. I think it's the best to explain it based on an example: In my data model the cubes always have a dimension "Version". Data has always to be entered on the current version which is stor...

hello, I have set up an picklist for an element with just three values. When I open the report set the value it works perfectly. Now I like to change the value back to blank. This doesn't work because the value is not in the list. I changed the picklist to static::A:B:C to show the empty value as we...

Hello Everyone, I'm getting the following error when I try to change my password via web (TM1 System 9.4.1). Operation Failed -------------------------------------------------------------------------------- System has encountered a problem while handling your request. Please try again. If you keep h...

Just tested it. To use the picklist with "hidden" dimensions (e.g."}testDim'") works. But it doesn't work to use a picklist in a "hidden" cube starting with a }.

Hi Guys, I like to offer a picklist for setting a attribute. For this I tried to insert a picklist in the control cube (}ElementsAttributesTest) of my dimension. For the element (same name as cube) I added a picklist. But unfortunaltely this picklist does not show up. Are there any limitation of usi...

I had the problem that I have to distinguish between 3 different kind of elements of the dimension. When I'm imoprting element to the dimension the element can be an "new one" (does not exist yet), "already existing". All other elements of the dimension (elements which are not in...

But how can I set the attribute with the status? When the metadata tab has finished the element is already in the dimension and it doesn't make any sense to use the dimix statement again. How can I flag that the element didn't exist before using a flag? any advice?