ISSUE IN MDX VIEW AS DATA SOURCE

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

ISSUE IN MDX VIEW AS DATA SOURCE

Post by mce »

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.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
scrumthing
Posts: 81
Joined: Tue Jan 26, 2016 4:18 pm
OLAP Product: TM1
Version: 11.x
Excel Version: MS365

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Post by scrumthing »

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.
There is no OLAP database besides TM1!
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Post by lotsaram »

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
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ISSUE IN MDX VIEW AS DATA SOURCE

Post by Steve Rowe »

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...
Technical Director
www.infocat.co.uk
Post Reply