Hi all,

We have virtual hierarchies in our 'Sites' dimension that are created using a TI process (CreateHierarchyByAttribute).
However, for a few sites (elements), this does not appear to work successfully as, when adding the virtual hierarchy to a view (in PAW or PAfE), their values are "lost".

As an example, this is an extract of the Sites Attributes showing the 'Geography' attribute:



The process includes this code:


This is a view without the Geography virtual hierarchy (zeroes are suppressed on rows):



This is the same view with the Geography virtual hierarchy added (zeroes are still suppressed on rows):



For some reason the first two sites (9114040 and 9114010) do not feature in the virtual hierarchy so they disappear from the view because their values are now zero.

I have looked through the Sites dimension and it's attributes for any discrepancies that might be a potential cause but other sites with the same attributes are being included in the virtual hierarchies successfully.
I have also looked through the process and there isn't really anything that looks wrong as these virtual hierarchies are created in the epilog of the dimension update process so nothing else is triggered afterwards.
I have also run the process so all hierarchies on this dimension should be synchronised.

Has anyone encountered this before or have any idea what may be causing this issue?

------------------------------
Martin Lipinski
------------------------------

#PlanningAnalyticswithWatson

Hi Martin,

What's not a 100% clear to me here is if the Geography hierarchy that you had created in the TI process actually contains the structure as expected or not. Does it? I.o.w. is this issue caused by the alternate hierarchy Geography simply not containing the sites in the hierarchy it represents or because something is off query time when finding the data for these intersections.

------------------------------
Hubert Heijkers
------------------------------

Hi Hubert,

Thanks for responding.

Those two sites do not appear in the created Geography hierarchy (or any of the other virtual hierarchies) even though they are in the Sites dimension with valid attributes that do appear in the hierarchy.

So, for example, All Geographies includes South East and South East includes 9015270, but it doesn't include 9114040 when it should contain both as they both have the same Geography attribute in the Sites dimension.

This is the total and parent levels which are correctly represented.
Most sites appear in their correct geographical subtotal, but there are a few sites, like the two mentioned, that do not.


------------------------------
Martin Lipinski
------------------------------

Original Message:
Sent: Tue April 28, 2020 03:55 AM
From: Hubert Heijkers
Subject: Virtual hierarchy issue

Hi Martin,

What's not a 100% clear to me here is if the Geography hierarchy that you had created in the TI process actually contains the structure as expected or not. Does it? I.o.w. is this issue caused by the alternate hierarchy Geography simply not containing the sites in the hierarchy it represents or because something is off query time when finding the data for these intersections.

------------------------------
Hubert Heijkers
------------------------------