TM1 Forum

Now released in PAfE 2.0.90

I'm expecting everyone will be looking at it soon enough, I'm thinking it might warrant an ongoing thread

Seems to have a lot of functionality and I don't want to be negative but some of the omissions are a bit problematic. I'm assuming they will be resolved in further releases.

https://www.ibm.com/docs/en/planning-an ... -universal

Of course we all want the new hierarchy data functions but I don't see anything in the roadmap for that.

Of course we all want the new hierarchy data functions but I don't see anything in the roadmap for that.

My understanding is that the TM1SET function does this, though I have never used it so I may be wrong.

I was waiting for the arrival of Universal Reports to start playing with TM1SET.

Maren

MarenC wrote: ↑Wed Sep 13, 2023 8:05 am

Of course we all want the new hierarchy data functions but I don't see anything in the roadmap for that.

My understanding is that the TM1SET function does this, though I have never used it so I may be wrong.

I was waiting for the arrival of Universal Reports to start playing with TM1SET.

Maren

Universal Reports rely on TM1Set and a number of other custom worksheet functions (The list is in the documentation) but the replacements for DBRW etc have not yet been released.

Universal Reports rely on TM1Set and a number of other custom worksheet functions (The list is in the documentation) but the replacements for DBRW etc have not yet been released.

So DBRW will not work with TM1Set if the TM1Set references another hierarchy?

Maren

MarenC wrote: ↑Thu Sep 14, 2023 7:07 am

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 the new function(s) into their slice tool. someone else can confirm.

But I would expect IBM to come up with new versions of the other functions ike ELCOMPN etc, just as they did for rules / TIs.

On one of the AMA's earlier this year they said that 1) Universal reports would end up replacing dynamic reports 2) they would release the functionally over time, and 3) they mentioned that they will have a conversion tool when the time comes.

So there is still a lot more before this add-in becomes what it arguably would have been expected to be when Server 11 was released. The published roadmap does not contain any further detail so the timeline is anyones guess.

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 does the whole conversion but at least I am hoping to find something that can do a partial conversion

Ardian

ardi wrote: ↑Sun May 05, 2024 11:19 pm 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

No this doesn't exist and never will unless a 3rd party comes up with something. Because PAfE also supports slice reports and active forms (they are just renamed as custom and dynamic reports). So the idea is that these should work "as is" without migration (yes the reality is a little different as not everything works the same and often things may need to be edited a little, or a lot, in order to work in PAfE, and obviously the more complex the report the more chance that it isn't going to just work without any rework.)

Universal reports are a new feature (or "capability" as IBM prefers to say these days) and so there is no migration path.

ardi wrote: ↑Sun May 05, 2024 11:19 pm 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 does the whole conversion but at least I am hoping to find something that can do a partial conversion

Ardian

About 6 months ago on one of the AMA's they said that they will build a migration tool. I imagine formatting would be a big challenge.
AND they said that UR's will evolve with time so at the moment the functionality may not provide what you need. If your Active Form / Dynamic reports have excel formulae which cannot be expressed in MDX or you are referencing multiple cubes then it doesn't support that. Note the URs work on cell insertion rather than row insertion. They showed a new report type "Static UR" the other day on the Q2 update.
I see URs at the moment as an additional useful function based on the case.
I wouldn't rush to UR's. If you have hierarchies and need reporting then it's all IBM is providing (Besides TM1VAL)