TM1 Forum

Looking back I believe the ISB has not been supported since TM1 10.x:
viewtopic.php?f=3&t=2119
Quite surprising to hear it still works sometimes!

To be clear, the totaling happens on the server, using the rollups in your dimension - so if new elements are properly charted when they are added, the total will be correct. The 'custom' report retrieves values against the dimension element.

TM1PY is hands down the best way to go. But if you are insistent on doing it by hand then you could have a dig round the TM1PY library to find out what that does to format the response. Watch out for volume issues - I've seen writeups by Paul Simon inter alia that Web Services aren't good for bulk d...

John Hammond wrote: ↑Wed Dec 09, 2020 10:01 pm In retrospect, I suppose, the PM path of revolution may not have been correct. That's like saying "The charge of the Light Brigade may not in fact have been a tactically prudent exercise". Although my great-grandfather fought in the Crimea, a...

This thread triggered some memories and I went looking back in our records. Found a response from James Fleming at Applix dated 15 Jul 2005 saying that (at the time) 64 bit Windows supported 16 TB. Also found a more recent post https://www.compuram.de/blog/en/how-much-ram-can-be-addressed-under-the-...

I recall that Hierarchy Sort has the useful side effect of removing duplicates - and it is supported by the MDX Record Expression feature:

I've done little or nothing with annotations - but I see that TM1PY supports them and the methods look quite straightforward:

• create(annotation)
• delete(annotation_id)
• get(annotation_id)
• get_all(cube_name)
• update(annotation)

Easily fixed - use weightings. This will also be faster. Adam is right that c level rules do not consolidate onwards.

Apologies - I was responding to declanr's post about the clashing use of 9510 and the totally unnecessary, untested split of TM1Web for a release that was, amazingly, described as Long Term Support

Perhaps IBM could sort out the dreadful mess they have made of the latest install? LTS version, my <unprintable>

A possibility - I got caught out getting Centos 8 from Centos themselves - but it turns out that only Centos 7 is supported. Sure this is documented somewhere :roll: I have run PAW on Centos 7 within Windows 10 Pro using both VMWare (Player) and (briefly - not a good experience) Hyper-V, connecting ...

Perhaps look at this?
https://code.cubewise.com/odbc-connect
Also, I recall this from earlier releases. Can't say whether it survived in TM1 11/PA:
https://www.ibm.com/support/knowledgece ... proxy.html

The drawback is that this dimension now has 100+ elements, for all kinds of special exceptions etc. Cleanup is especially hard (how do you figure out if one element is used in a cube somewhere in a big model?), maintenance is hard, visually it is not appealing at all. Really you don't need anything...

Surely you should ask IBM for their roadmap for SAP connectivity :shock: One possible way forward would be to use TM1PY with a Python SAP library eg: https://sap.github.io/PyRFC/ or (from SAP themselves) https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/d12c86af7cb442d1b9f852...

It's arguably a step too far to go to TM1PY just for a decent set of coding structures, but it certainly makes the experience more enjoyable.

Perhaps Marius would be interested in adding it to TM1PY in his spare time...

Most likely you have selected to skip consolidated elements but the selections in one or more of your dimensions have no N level elements. Easiest way to check this is to export the view to a file. It will have a cma extension but is in fact a csv file.

tomok wrote: ↑Thu Jul 02, 2020 1:42 pm HighKeys wrote: ↑Thu Jul 02, 2020 12:15 pm why you dont create a SQL View and just import the View? Better yet, use a stored procedure. Each individual INSERT INTO statement is going to have to be compiled before execution. Depending on how often you call the ...

Per this thread, a TM1 string cannot be > 32k so that would limit an ODBCOutput statement.
https://www.tm1forum.com/viewtopic.php? ... ize#p70027

Spending some time developing systems with 'another' cube engine which mandates web for development, I worked round the issues by opening multiple connections in different tabs which I could tear off and rearrange. Main gotcha was that changes in one session would not show up in another without doin...