ViewZeroOut on MDX views

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

ViewZeroOut on MDX views

Post by PavoGa » Thu Oct 08, 2020 12:47 pm

2.0.09 was supposed to allow the use of ViewZeroOut again MDX views. As mentioned in some other threads, ViewZeroOut was virtually useless if leaf elements existed in alternate hierarchies but not the base dimname:dimname. I was hoping for a resolution of this issue with ViewZeroOut against MDX subsets.

Admittedly, this is my first attempt at, but it is not working. Here is the MDX:

Code: Select all

SELECT
    {[Version].[Active_03]}  ON COLUMNS,   
    {[Organization].[Mapping].[Mapping]} * 
    {[HR Level].[Mapping].[Mapping]} * 
    TM1SubsetToSet( [Fiscal Period], "tmp_sys.53.Factor Loading_07160310_98051") * 
    {[lookup.Mapping Measure].[53Year].[tmp_sys.53.Factor Loading_07160310_98051c]}  ON ROWS 
FROM [lookup.Mapping]
This view renders with no problem in PAW or ARC (like ARC! well, except for the text editor, but I'm hardcore on Notepad++). However, when executing the ViewZeroOut against this view, this message pops up:

Code: Select all

Error: Prolog procedure line (4): Invalid key: Dimension Name: "Organization", Element Name (Key): "Mapping"
Yes, the [Mapping] element exists in the alternate hierarchy [Mapping] on the organization dimension.

Looks like ViewZeroOut still only works only with elements in the base hierarchy? Please tell me there is something to this I am missing.

And before someone chimes in about it, yes, we use leaf elements in alternate hierarchies that are not in the base hierarchy and the only reason we have to put them in the base is because of functions like ViewZeroOut not working with alternate hierarchies.
Ty
Cleveland, TN

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

Re: ViewZeroOut on MDX views

Post by PavoGa » Thu Oct 08, 2020 1:08 pm

Wim Gielis wrote:
Tue Jan 14, 2020 9:30 pm
I would go for 2.0.8 unless you would want to use the feature:
Use the ViewZeroOut TurboIntegrator function on MDX views (https://www.ibm.com/support/knowledgece ... pport.html) or other features that were added in 2.0.9.

On a related note, PAW 2.0.48 has been released today:
https://www.ibm.com/support/knowledgece ... s_paw.html
Wim, saw this post and I wonder if the MDX query may be the issue. I'll fiddle with it some more.
Ty
Cleveland, TN

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

Re: ViewZeroOut on MDX views

Post by PavoGa » Mon Oct 12, 2020 12:54 pm

Has anyone used ViewZeroOut against a view created by MDX?

It is failing and complaining that the element in the hierarchy it needs cannot be found. It is the hierarchy element, not the hierarchy it is complaining cannot be found, as I changed the element name to determine exactly what it was complaining about.

Code: Select all

Error: Prolog procedure line (4): Invalid key: Dimension Name: "Organization", Element Name (Key): "MappingTest"
The view is created as a permanent view renders after the process executes without a problem. Setup another TI to execute manually after the process completes and same failure.

If anyone is doing this, would like to know and what the MDX is.
Ty
Cleveland, TN

Post Reply