Search found 2130 matches

by Wim Gielis
Mon Sep 23, 2019 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppressing "0" in ASCIIoutput (Data extract ti)
Replies: 6
Views: 134

Re: Suppressing "0" in ASCIIoutput (Data extract ti)

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.
by Wim Gielis
Mon Sep 23, 2019 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppressing "0" in ASCIIoutput (Data extract ti)
Replies: 6
Views: 134

Re: Suppressing "0" in ASCIIoutput (Data extract ti)

Then your IF must be wrong. Or the IF targets the wrong cells.
by Wim Gielis
Mon Sep 23, 2019 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppressing "0" in ASCIIoutput (Data extract ti)
Replies: 6
Views: 134

Re: Suppressing "0" in ASCIIoutput (Data extract ti)

Did you wrap the CellGetN's in an IF statement, to check whether they are different from 0 ?
by Wim Gielis
Thu Sep 19, 2019 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recalculate specific cells ather than whole Worksheet
Replies: 7
Views: 146

Re: Recalculate specific cells ather than whole Worksheet

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...
by Wim Gielis
Mon Sep 16, 2019 11:23 pm
Forum: OLAP Jobs
Topic: Cognos TM1 Consultant - 100% remote!
Replies: 1
Views: 360

Re: Cognos TM1 Consultant - 100% remote!

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.
by Wim Gielis
Thu Sep 12, 2019 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about formatting rule calculated cells in TM1
Replies: 3
Views: 369

Re: Question about formatting rule calculated cells in TM1

They should still be formatted as currency.
Did you apply formatting to elements of other dimensions in that cube ?
by Wim Gielis
Thu Sep 12, 2019 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules replicating itself
Replies: 4
Views: 213

Re: Rules replicating itself

Then I would put the notes below, after Skipcheck.
by Wim Gielis
Thu Sep 12, 2019 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules replicating itself
Replies: 4
Views: 213

Re: Rules replicating itself

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.
by Wim Gielis
Thu Sep 12, 2019 3:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Displaying data tables according to dimension elements
Replies: 3
Views: 218

Re: Displaying data tables according to dimension elements

That’s what we would call zero suppression on the outer row dimension...
by Wim Gielis
Wed Sep 11, 2019 7:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Displaying data tables according to dimension elements
Replies: 3
Views: 218

Re: Displaying data tables according to dimension elements

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 ?
by Wim Gielis
Wed Sep 11, 2019 12:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms with Filters
Replies: 5
Views: 206

Re: Active Forms with Filters

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

Code: Select all

="TM1FILTERBYLEVEL( DESCENDANTS( {[YourDimension].[" & A1 & "]}), 0)"
by Wim Gielis
Wed Sep 11, 2019 12:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DB function is not pulling data from the source cube
Replies: 5
Views: 469

Re: DB function is not pulling data from the source cube

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...
by Wim Gielis
Tue Sep 10, 2019 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms with Filters
Replies: 5
Views: 206

Re: Active Forms with Filters

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...
by Wim Gielis
Tue Sep 10, 2019 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PickList is not visible with IFERROR formula
Replies: 1
Views: 147

Re: PickList is not visible with IFERROR formula

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...
by Wim Gielis
Tue Sep 10, 2019 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load particular records in a cube using TI
Replies: 1
Views: 223

Re: Load particular records in a cube using TI

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...
by Wim Gielis
Mon Sep 09, 2019 8:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 540

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

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.
by Wim Gielis
Mon Sep 09, 2019 7:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 842

Re: adding button to pax sheet and publish in paw

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.
by Wim Gielis
Fri Sep 06, 2019 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Not Loading All Values
Replies: 9
Views: 1105

Re: TI Process Not Loading All Values

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.