TM1 Forum

Posted: **Mon Jun 15, 2020 9:20 pm**

I just found this:

https://www.ibm.com/support/pages/apar/ ... status-_-E

PH16537: TI-PROCESS WITH VALID BUT EMPTY MDX VIEW AS DATA SOURCE THROWS MAJOR ERROR AND ABORTS

When a TI process has as DatasourceType='VIEW' and the view is a
MDX view where the view syntax is correct but the view happens
to return empty due to column and/or row SELECT NON EMPTY
suppression then the process will throw a major error and abort
rather than skipping the metadata and data tabs and proceeding
directly to the epilog.
Error: Prolog procedure line (0): Unable to open data source
"cubename"

This issue makes this feature no-go. This is a major problem.

Posted: **Tue Jun 16, 2020 4:47 am**

That’s one of mine. I was told that it should be fixed but I admit I haven’t tested it as I have more or less given up on MDX views as data sources for TI due to the hoops you need to jump through in constructing the MDX in order to achieve variable assignments in the same order as the dimension order in the cube.

Posted: **Tue Jun 16, 2020 8:35 am**

AFAIK there was the same issue a couple of years ago when you sent an empty MDX via the rest api. But nowadays that is not an issue anymore, I think.

Posted: **Tue Jun 16, 2020 8:51 am**

FYI this has previously been discussed here https://www.tm1forum.com/viewtopic.php? ... set#p73290

And the issue with viriable assingment order (and the needed workaround in how to build the MDX select query) is discussed here https://www.tm1forum.com/viewtopic.php? ... iew#p73332

Posted: **Wed Jun 17, 2020 8:52 am**

Just to mention I've been doing a lot with MDX views as datasources recently and not hit any issues with dimension order, its not hit my radar at all.

That's not say it doesn't still exist of course...

TM1 Forum

ISSUE IN MDX VIEW AS DATA SOURCE

ISSUE IN MDX VIEW AS DATA SOURCE

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Re: ISSUE IN MDX VIEW AS DATA SOURCE