Avoiding TI abort when using ViewCreateByMDX

Post Reply
User avatar
PavoGa
Community Contributor
Posts: 359
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Avoiding TI abort when using ViewCreateByMDX

Post by PavoGa » Tue Jul 30, 2019 9:08 pm

We are moving into using ViewCreateByMDX pretty heavily. One issue we have run into is testing whether we are going to return a data set or not. If it does not, the TI aborts instead of just skipping over the METADATA/DATA procedures like a traditional view does.

One method is to do a CELLGETN against an intersection that would have data and execute the ViewCreateByMDX only if the value is <> 0.

This is popping up when using RUNPROCESS and everyone freaking out when the server log shows the abort. Working on it, but wondered what other ways people are handling this?
Ty
Cleveland, TN

User avatar
macsir
Community Contributor
Posts: 638
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Avoiding TI abort when using ViewCreateByMDX

Post by macsir » Wed Jul 31, 2019 12:10 am

Hi, I had similar problem when using SUBSETCREATEBYMDX and then switch to function SUBSETMDXSET, which allows process goes to epilog. Maybe you can replace yours with ViewMDXSet as well? :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

User avatar
PavoGa
Community Contributor
Posts: 359
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: Avoiding TI abort when using ViewCreateByMDX

Post by PavoGa » Wed Jul 31, 2019 12:38 pm

macsir wrote:
Wed Jul 31, 2019 12:10 am
Hi, I had similar problem when using SUBSETCREATEBYMDX and then switch to function SUBSETMDXSET, which allows process goes to epilog. Maybe you can replace yours with ViewMDXSet as well? :D
Talking ViewCreateByMDX, not SubsetCreateByMDX.
Ty
Cleveland, TN

lotsaram
MVP
Posts: 3268
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Avoiding TI abort when using ViewCreateByMDX

Post by lotsaram » Mon Aug 05, 2019 2:47 pm

Hi Ty,

I hear you. We have come up against the same issue. IMHO this is a defect and the behaviour should be the same as for a native view (no error, skip straight to epilog).

In testing we found that the error below
Error: Prolog procedure line (0): Unable to open data source "CUBENAME".
... can be avoided if rather than doing NON EMPTY in the MDX Expression we apply ViewExtractSkipBlanks after the view is created.

The workaround to do CellGetN on some consolidated intersection representing the view is the one we are also using though.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply