TM1 Forum

JohnO

3. Create a subset with the 2 measures you want to add up, and reference the subset name in your DBRW formula. This is a undocumented feature but it still works and I have used it for more than 15 years as a workaround to create custom aggregations In the PAfE world this is what DEFINECALC can do, ...

JohnO

We don't have a natural aggregation for the 2 measures so I'm trying to keep it to 2 DBRW's. Why not? My words were "natural aggregation", by that I mean the 2 measures do not naturally aggregate from the perspective of a financial model or from the perspective of usability. In this case ...

JohnO

I logged a support ticket with IBM. This functionality is not supported. " I have confirmed with the Development team, compound DBRW usage like this is not supported in tm1web. Please see this technote: Compound DBRW formulas are not supported in TM1 Web https://www.ibm.com/support/pages/compou...

JohnO

MarenC wrote: ↑Fri Aug 01, 2025 12:31 pm
The formula is subtraction, so DBRW()-DBRW()
Well you said initially,

I have a report in PAfE where I have DBRW() + DBRW()
My apologies and thanks for your suggestions

maren

JohnO

I have looked to ensure the users are in the proper write group, there is proper cube security, there is no dimension or element security on any of the dimensions or measures, there is no locks or holds, and the users are not set to read only. Any advice on where to look next? Thanks Cell security?...

JohnO

Thanks. That's interesting but not the case for me.

The measures are in the column heading and the only difference between the two DBRW's is the measure. The formula is subtraction, so DBRW()-DBRW()

JohnO

Hopefully a very simple one. We are using 2.0.93 PAfE and 2.0.93 Spreadsheet services. I have a report in PAfE where I have DBRW() + DBRW(). The DBRW's are pointing to separate measures. In PAfE this report works fine but in TM1Web no rows are returned. If I pull it back to one DBRW it is fine in bo...

JohnO

Hi gtonkin, As mentioned previously, I use IBM with an excel addin so I don't have access to Cognos Automation because this is provided through Microsoft I believe. So the link doesnt really help me. A bit of history might be useful. Back in 2007 (I think), Cognos acquired Applix who owned TM1. TM1...

JohnO

Try TM1VAL with the parameter to clear

JohnO

There is a tm1s.cfg setting that controls this exact behavior. RulesOverwriteCellsOnLoad https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/c_rulesoverwritecellsonload.htm Thanks, I wasn't aware of this one. I was sure that in previo...

JohnO

Well there's more to it than the title. We are using 2.0.19. For our depreciation model we have been loading forecast depreciation from an external system. We recently changed that to TM1 calculating the forecast. Before deploying the rules I did not clear all of the existing forecast data. These ru...

JohnO

Steve Rowe wrote: ↑Wed Sep 18, 2024 1:30 pm scribe, subscribe !

? Too cryptic for me.

JohnO

Andy Key wrote: ↑Tue Sep 17, 2024 2:58 am Switch the order of your Scan parameters. You're currently looking for the text of the existing rule inside a string that only contains an apostrophe.

How obvious.

Thank you.

JohnO

This should be a simple one. The following is not returning a positive number. I am being blind to something? sExisting_Rule = CubeRuleGet('INP Capital Planning'); nTargetCommaPosition = scan(sExisting_Rule,char(39)) ; asciioutput('Test_Scan_Rule_File.csv',numbertostring(nTargetCommaPosition) ); nTa...

JohnO

Maybe use one of the tools from IBM Partners who have put this into their Excel add-in's while IBM has failed to do so.

JohnO

Very recent addition to PAW https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=2095-new-synchronization-settings-allow-customized-display-hierarchies So this supports the base cases and is much better than before (ie: nothing). What it doesn't allow is the setting of custom MDX in the target...

JohnO

Posted too early. Found my answer:

https://community.ibm.com/community/use ... 87e6ae9e0c

JohnO

Expanding on the title. We have been using 2.0.93 for a few months. If I have a range of DBRW's then copy that range, then paste-as values directly on top of that range what should I expect to see? What is happening is that the DBRW's remain. A couple of our users are adamant that it used to past va...

JohnO

I know that the use of + as the first character of an Element name is not recommended/supported as per the following from IBM. "Element names and MDX expressions Do not use + or - as the first character of an element name. Although only the first element in a subset when slicing to active form ...

JohnO

As the title says I need to get forecast depreciation from Navision to TM1. I have no expertise in Navision beyond querying some tables but there is a report that generates forecast depreciation. I have been provided with 2 C/AL code units pertaining to depreciation and I am thinking that these may ...

TM1 Forum

Search found 124 matches

Re: Dynamic report with multiple DBRW's per cell

Re: Dynamic report with multiple DBRW's per cell

Re: Dynamic report with multiple DBRW's per cell

Re: Dynamic report with multiple DBRW's per cell

Re: Users unable to direct enter into a form

Re: Dynamic report with multiple DBRW's per cell

Dynamic report with multiple DBRW's per cell

Re: VBA Code for PAFE

Re: Zero out with DBS on consolidated element

Re: Does the introduction of a rule to an area ever remove any existing data in that area?

Does the introduction of a rule to an area ever remove any existing data in that area?

Re: Scan of rules not returning what I am expecting

Re: Scan of rules not returning what I am expecting

Scan of rules not returning what I am expecting

Re: Excel Macro - save as values and email

Re: Ability to assign 'selector' widget element as a variable to MDX view in PAW

Re: PAfE - Copy and paste-as values

PAfE - Copy and paste-as values

Use of + in Element names

Navision forecast depreciation > TM1