cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to filter out by different hierarchy using tagged query.

0 Kudos
563

Hi Experts,

We are using a tagged query to get the master data and hierarchy data from S/4 HANA (via CDS View) to PaPM Cloud by referring this blog : https://blogs.sap.com/2022/10/06/sap-papm-cloud-introduction-of-query-based-master-data-and-hierarch...

For one of the field (which has two different hierarchy names) , we have a requirement to filter out by different hierarchies in the processing part. But from what we have observed, we can specify only one particular hierarchy name in the ‘settings’ section of the field as shown below in the screenshot. This would not allow us to filter by the other hierarchy.

So, kindly let us know the solution to this.

hierarchy-name.png

Regards,

Soundarya C Adiga

Accepted Solutions (0)

Answers (1)

Answers (1)

KristinaDjordj
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

It is expected behavior to select only one Hierarchy for a field. Still, there is a way to see values coming from the other hierarchies as well.

In case you have Hierarchies enabled for a field and you choose one hierarchy, you will be able to see values coming from the chosen hierarchy only as shown in the screenshot below.

But, if you disable Hierarchies option for a field, later in modeling and processing you will be able to see values coming from all available hierarchies (in your case that's two). Here is how it looks like.

Then you can perform filtering in Show/Analyze screen based on the hierarchies you need if there are more of them and save different layouts based on the expected results.

Hopefully this helps.

Kind regards,

Kristina

0 Kudos

Hi Kristina Djordjevic,

Thanks for your reply.