TM1 Forum

Maybe... take the absolute value and test whether it's smaller than 0.01 for example. 0 is not always 0.

Other than that, use additional AsciiOutput statements to properly debug your code, or use the TI debugger tool provided by IBM.

Then your IF must be wrong. Or the IF targets the wrong cells.

Did you wrap the CellGetN's in an IF statement, to check whether they are different from 0 ?

Macro-enabling should not add more overhead unless you intend to add a lot of macro code-even then, this should not impact size too much. Add a module to your workbook first. The code is simple: Sub CalculateSelection() Selection.Calculate End Sub Bind a short-cut key to the macro after you have cr...

Hello,

Welcome !

But euhm....

kbck wrote: ↑

Mon Sep 16, 2019 1:31 pm

Rate depends on your experience: 110-120 PLN/h it is about 25-27 Euro/h.

Seriously ?

Mowing the lawn with my grandmother pays off better, certainly if our government takes about half of it.

What is the logic for the mdx of the second row dimension ?

They should still be formatted as currency.
Did you apply formatting to elements of other dimensions in that cube ?

Then I would put the notes below, after Skipcheck.

So, what is the structure you normally have, which leads to the structure that we see in your post ?
I would add notes after the initial statements of feedstrings, skipcheck, ... Nothing on top of these initial statements.

That’s what we would call zero suppression on the outer row dimension...

You're welcome, good luck with the courses.

So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3.
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?

As there is TM1DRILLDOWNMEMBER, DRILLDOWNLEVEL, ... and also to for the arguments ALL and RECURSIVE,
I tend to use Descendants:

No, you have to be rather explicit there, and reference 1 element in (1 hierarchy of) the target dimensions. It could be level 0 or consolidated, it could be retrieved with whatever logic you deem necessary (like an attribute or string concatenation or other) but eventually what you mention as argum...

Use an MDX statement to return these children, based on the value of a cell (like a SUBNM). You can fully customize this. In the MDX argument of the TM1RPTROW function, refer to the (hidden) cell that contains the MDX expression. That MDX would be a string where a cell reference to the project choic...

You should not wrap the DBRW formula for the picklist in another function. Even more, you should NEVER wrap ANY DBRW formula in any other function. I would use some clever conditional formatting to hide or show the picklist / DBRW. For example, use DIMIX on the elements such that only if all DIMIX'e...

Either you change the query for the datasource to include only the records needed, either you have logic in the TI process to count the number of records that have been treated. If this means excluding the last 5, for example, it can mean that you need to use a helper process to know how many record...

Hi Paul,

If you could provide a PRO file and some dummy data / dimensions / attribute values ?
I can run some tests with the code on a 2.0.8 installation.

The messages can be customized by using for example: =M1
whereby cell M1 contains the error message. That could come from a DBR formula or similar solution.

Limit the ODBC query to 1 record (that does not work).
Navigate to the exact cell. If it works, there will be something else that puts the cell again to 0. Like another record to the same cell.
If it does not work, you can investigate further.