Cube View using attribute based Hierarches. Cannot use as TI data source

Post Reply
JohnO
Posts: 11
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: Office 365 16

Cube View using attribute based Hierarches. Cannot use as TI data source

Post by JohnO » Fri Feb 12, 2021 5:53 am

I'm interested to see if others have tried this.

I have a product dimension and have created attribute based hierarchies (Brand, Size, Colour etc) and then I created a cube view. The cube view created is pure MDX, not accessible in the old interfaces which is fine. What I wanted to then do was to use this cube view as a data source for a TI as we can do with traditional cube views. The Process editor in PAW had no objections to me using this view as a data source but expected the input dimensionality to be the same as the cube, not the same as the view. When I ran it of course it errored on all lines because there was a dimensionality mismatch. Of course one of the problems is that views which use attribute based dimensions can have variable numbers of dimensions so there needs to be a much smart way of using it as a data source than the traditional approach.

I'm wondering if anyone else has tried to go down this path and whether they found some other approach. I did try the approach of using ViewMDXGet (Which worked) to extract the MDX but I cannot see a way of then meaningfully using it to generate a data set within the PA world.

User avatar
Steve Rowe
Site Admin
Posts: 2152
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by Steve Rowe » Fri Feb 12, 2021 10:08 am

Hi JohnO,

I'm using MDX views as datasources in TIs so there should be no issue there.

From where you are saying you have multiple hierarchies from the same dimension in the view and therefore the dim count for the view does not match.

I would try pointing the TI at a cube (create one if you need to) with the same number of dimensions as there are hierarchies and dimensios in your source view.

Then switch the datasource at runtime to the actual cube and view you want to use.

It may be that this won't work either as it is probable that a TI is hardcoded to assume the same number of inputs as there are dimensions in the cube.

Whilst I can see why you would want to do what you are attempting, if your hierarchies are driven by attributes then these will still be available to you when processing a native view, so you should just be able to look up the attribute values when processing a view.
Technical Director
www.infocat.co.uk

JohnO
Posts: 11
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: Office 365 16

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by JohnO » Fri Feb 12, 2021 11:20 am

Thanks. But the idea is that I want the user to define the view and then I want to use what they have defined and use that as a datasource. Do it needs to handle attribute dimensions and variable count . I do have a totally different approach to fall back on which involves legacy items but it will not be driven by a user engagement in the standard UI as one of the problems with a legacy view is that a user can only use attributes to filter dimension elements via MDX, which is very nasty for a user. My approach will involve them defining selections differently but they will not be able to see the results until they click a button and a view is generated.

Oh and there was another issue I encountered. When a user creates a view it is private and so we need to make it public to consume it in a TI. But PublishView does not work on MDX views.

MarenC
Posts: 140
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by MarenC » Fri Feb 12, 2021 1:12 pm

Hi,

Why can't you grab the Client inputs in PAW via the client attribute cube and build a view with MDX based on what the client enters into these attributes?

Maren

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

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by PavoGa » Fri Feb 12, 2021 2:13 pm

This sounds like this issue:

viewtopic.php?f=3&t=14714

which is a known issue and has been recognized by IBM as a bug. Using alternate hierarchies in an MDX view as a datasource does in fact change the order in which dimensions are processed.
Ty
Cleveland, TN

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

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by lotsaram » Fri Feb 12, 2021 4:00 pm

PavoGa wrote:
Fri Feb 12, 2021 2:13 pm
... which is a known issue and has been recognized by IBM as a bug. Using alternate hierarchies in an MDX view as a datasource does in fact change the order in which dimensions are processed.
I have a case linked to "PH24729 WRONG VARIABLE ASSIGNMENT ORDER IN MDX-VIEW PROCESSING" which has been open for close to 2 years. The last update was in April 2020 which was to inform that the defect was recognized. I haven't tested in 2.0.9.5 but as PH24729 wasn't listed in the fixes for either 2.0.9.4 or 2.0.9.5 I'm assuming this frustrating bug is still there.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

JohnO
Posts: 11
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: Office 365 16

Re: Cube View using attribute based Hierarches. Cannot use as TI data source

Post by JohnO » Sun Feb 14, 2021 11:29 pm

lotsaram wrote:
Fri Feb 12, 2021 4:00 pm
PavoGa wrote:
Fri Feb 12, 2021 2:13 pm
... which is a known issue and has been recognized by IBM as a bug. Using alternate hierarchies in an MDX view as a datasource does in fact change the order in which dimensions are processed.
I have a case linked to "PH24729 WRONG VARIABLE ASSIGNMENT ORDER IN MDX-VIEW PROCESSING" which has been open for close to 2 years. The last update was in April 2020 which was to inform that the defect was recognized. I haven't tested in 2.0.9.5 but as PH24729 wasn't listed in the fixes for either 2.0.9.4 or 2.0.9.5 I'm assuming this frustrating bug is still there.
Thanks, I think what I am encountering is an extension of that issue. Not only does the order of dimensions in the MDX view not match that in the cube, the dimensionality itself is different (Using attribute based dimensions) and given I want the user to define the view we could never pre-define a TI based on such a view with the current design of TI's. I think this is more than a bug, I think it's a very fundamental matter that TI's expect the cube view to match both the dimensionality and the dimension order of the cube.

Post Reply