TM1 Forum

Hi all, I have a cube with one dimension having all leaf elements and one "total" element. To zero out a slice I want to use DBS(0,"Cube", "Dim1", ...) This doesn't work. There is no error, simply nothing happens. I also tryied DBSW(0,"Cube", "Dim1",...

OK, thanks. I realized that by simple try and error. So my solution is a cube with rules and then request that cube with checking values > 0. Unfortunatly I need a cube for every dimension with this filter feature.

Yes, I already did. Example:
This also returns nothing. If I change "> 0" to "= 0" I get all elements. I have totally no clue!

I have a cube (}TM1Config_UserReportDimElements), where I store selections of the user. Because they can select multiple elements of a dimension, I have a dimension "}numbers" which only include number elements "1" ... "20". So I can store each element the user has has ...

Interestingly! But I didn't get it complete. So there is an attribute for }Clients, so each user has his own subset for elements of "products", right? But where is his selection in the report used? He selected "Departement 100" in this report, so how does this information influen...

When selecting an element for a dimension, I like to restrict another dimension depending on this selection. So in TM1Web I use 100% Excel functionality. I create a subset or a c element which represents my first selection. Let's assume I selected a department (100). With this ID I had created at im...

If this is a dimension with all elements as N elements, a rule will always be a N rule, but as fast as a C rule, because it simply does the calculation for itself (one time) without further aggregation.

In PAW I have the option to sync controls with each other by dimensions. When I define a Report in Excel and upload it to TM1Web, I can also use this in PAW as a visual. But its values are not offered outside to syncronize them. I can save the selected elements in a special cube and make the other P...

@burnstripe: Yes, I also tried "[KW].CurrentMember.Name". So I didn't understand, what kind of data is
- CurrentMember.Name
- CurrentMember

I assumed they are simply strings, so if "202101" works, it should work with any kind of strings.

Oh, that's simple. I want a flat dimension (}KW_N) , so I don't need any special rule or feeders. Just take the data from another cube.

Good to know, so I don't need to search for it. Thank you very much.

Additional question:
Using Picklists in special cubes only offers me a simple dropdown list. How can I use the subset editor shown by SUBNM, which also has these filter functions for level, pattern and also hierarchical selection? In large dimensions a simple flat list will be terrible.

Hi All, I'm facing the following problem: I want a stacked bar chart using Excel. So no special functionality of PAW available. I have a number of periods, used for rows, and a number of materials used for columns. Both are defined by a dynamic Subset via MDX. So I need to put the materials in the c...

Hi all, I discovered a strange behavior. I use a cube with dimensions, which have the same elements as the dimeniion in which I want to define a dynamic MDX based subset. So I have I dimension "KW" and a cube (}FILTER_KW_ORG) with 4 dimensions: }KW_N, }KW_N_Von, }KW_N_Bis and }FILTER_KW. T...

Hi, I'm searching for an opportunity for the users to caculate their own aggregation. I read about UDC. But actually I'm using Perspectives, in future I will use PAFé. I tried DefineCalc as a function in an Excel report, but this functions seems to be unknown. I'm using version 2.0.9 (Server 11.8.02...

I have several cubes with very limited data on a very large number of elements. So there is an information, how much output of a product (# > 10.000) can a specific maschine (# > 5.000) produce in one time period. [Maschine][Product] <> 0 is only set for 1 or 2 products. Then I have costs per maschi...

Hi all, I have a report which I should rebuild using TM/1. It is a dynamic area showing some products and their volumes. If I click on one of them (maybe with a value writing back a "1" to a helper cube) in another dynamic area below the one above some more details should be listed. Is it ...

Hi, I just wanted to use the TI Debugger in PAW. When I first started the "DEBUG" run, I got the message: Command rejected - TI debugging is disabled in tm1s.cfg OK, with some search I added EnableTIDebugging=true later on EnableTIDebugging=T to tm1s.cfg of the data model. Then I restartet...

Hi, I try to build an nice looking input dialog. So I want (Excel-Style) an input cell and a very small row below to have a delimiter for the input fields below. Unfortunately all settings belonging to row height in the pattern rows are ignored. The height of the first row in the data area is used a...

Wow.
Lets assume, I have a simple active report created by the View builder in Excel. Accounts in the rows (row header).
How could I react to a double click on an account name to do some changes, e.g. drill down or drill down?