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