TM1 Forum

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()

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...

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...

Try TM1VAL with the parameter to clear

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...

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...

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

? Too cryptic for me.

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.

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...

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.

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...

Posted too early. Found my answer:

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

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...

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 ...

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 ...

Perhaps the IBM Community https://community.ibm.com/community/user/businessanalytics/discussion/migrating-from-rich-tier-usage-to-modern-planning-analytics-on-cloud-webinar?ReturnUrl=%2fcommunity%2fuser%2fbusinessanalytics%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d8fde0600-e22b-...

Wim Gielis wrote: ↑Sat May 25, 2024 5:43 pm Therefore, let's add in ";" in front of and after the search string (the cube value):

Even better.

Thanks Wim

Hi John, You could do this using the Generate() function by using the 3rd parameter to concatenate the members into a string. Once we have a string we can then use INSTR() to test if the member's attribute/lookup value matches to something in the string and keep if it does. Thanks George That was a...

The only way to clear the thread is to restart the DB. It doesn't respond in Top / Admin console. I had this a couple of years back with an Oracle source. I worked with IBM support. It was not respecting the config timeout setting. Killing the odbcproxy exe will prevent restaring the tm1 service.

I have a cube with 2 dimensions, very similar to an attribute cube. First dimension is our Asset dimension, the second is a set of measures, one of which is the Profit Centre that the asset is associated with. This is updated by the users via a picklist. And yes this could then be represented as a t...