TM1 Forum

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

I have installed PA 2.0.9.19, and found that only basic rule editor can be run in architect. i tried to set 'AdvancedRulesEditor' in tm1p.ini, however it doesn't work as expected, and IBM online document mentioned that advanced rule editor was deperciated since PA 2.0.7. Is there any workaround to ...

Hi, Can someone let us know if PAW reports can be opened in PAX? I know we can open PAX reports published to PAW and can be opened. Thanks, Paul. You may mean opening PAW "views" in PAfE. A PAW view being something that contains more than a MDX statement. One or more PAW views can reside ...

Hi guys, Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful We have lots of websheets with Active Forms which are really dynamic, so I know there will be impossible to find a utility that ...

Try using Application.EnableEvents = False before modifying the cell formula. Then .Dirty method on the range. Then trigger calculation. Thanks William. I was able to get it to work by doing this. Specifically, with the add-in loaded I was able to disable events once at the beginning of the routine...

I should also say that Sendkeys("F2") appears to work, again with the add-in active. However I have experienced crashes, though not as severe as using .dirty

In your VBA code, could you not set the cells you are updating to Dirty using the .Dirty method? This should force a recalculation of the cells next time the sheet is calculated. George, that worked (Sort of). What I have found is that PAfE has to be loaded but no connection /login is necessary for...

I have a problem which is not strictly a PAfE issue but I know some here are still into VBA I am using the following to repoint the cube source of the formulae c.Formula = Replace(c.Formula, "$B$1", "'XX'!$B$1") It updates the forumla fine but the revised formula does not work un...

There is a setting where locking is reported in TM1Server.log. This is a good place to start to gain insight. I used RunProcess in the same manner in my prior role and had a lot of problems with locking. When these specific locks were encountered the parallel processes would go into serial mode. And...

We are in the process of upgrading from 2.0.9.1 (tm1s.exe 11.8.00000.33) to 2.0.9.15 (tm1s.exe 11.8.01700.1) Start with this and change your plans: https://www.ibm.com/support/pages/node/6856457 In terms of your questions I recall there were changes around .12 or .13 regarding text file loads and u...

What you are looking for is something IBM has talked about doing for a long time, but I don't see it on the roadmap. https://bigblue.aha.io/published/30f7b700d5eb7d18cfdd19c793f4a10d?page=4 Basically it would be an extension of synchronisation where the target set MDX is dynamically driven by the s...

As a example I have a simple PAW Book with 1 View, I have dragged out 2 dimensions for user to filter the view. 1. Dimension is "Container Size" 2. is "Destination" I want the Destination subset to only show the destinations which have data for that Container Size. I'm reduced t...

- finding function that recreates hierarchy by attribute that don't require using HierarchyDestroy before (using CreateHierarchyByAttribute without using HierarchyDestroy before returns error) I see CreateHierarchyByAttribute as just a way of simple introduction to building hierarchies. It's very l...

I've already answered my question.

I had this setting in my config.

SQLRowsetSize=100000

When I comment it out everything is ok. Looks like a bug there.

I have raised this with IBM Support but thought I would ask if anyone has seen this. We have an ODBC query against a PostgreSQL materialised view which returns 72,000 rows. Using ODBC in Excel all rows come through fine. In a TI any rows past 65536(2^16) have string values set to null and numeric va...

the other which bugs as soon as I put myself on totals for the dimensions You need to be much clearer and detailed if you are seeking help. eg: 1) Does the dynamic report return the expected data when you REBUILD with the workbook open 2) Do you receive any error messages 3) How have you constructe...

So DBRW will not work with TM1Set if the TM1Set references another hierarchy? Maren No, different functions are required for cell read and cell send etc. IBM showed DQR and some of the new worksheet functions almost 3 years ago when the release of DQR was then imminent. I think Cubewise have built ...