3435773 - No data is shown in the table of the target page after applied a filter on Hierarchy dimension through hyperlink in SAP Analytics Cloud (SAC)

No data is shown in the table of the target page after applied a filter on Hierarchy dimension through hyperlink

SAP Analytics Cloud 2024.2

1. Open the problem Story.

   The story contains two page, each page has a table use different model,  they both have a hierarchy with same name "dimension A" and they are linked dimension. 

   Hyperlink was added to page 1's table linking to page 2.

2. Go to the second page by hyperlink.
   => Note that filter has been applied by linking from the first page and there is no data in the table which is not expected as it has data for that filter.

• The root cause of the issue with filtering across models functionality is a longstanding limitation of the feature when linking dimensions which do not have a hierarchy active by default and then filtering those dimensions on a hierarchy.
• When such dimensions are linked the "Link on Matching Hierarchy" performance optimization cannot be activated and this results in filters on the linked dimensions being propagated using the indirect propagation workflow which involves fetching the tuples of all linked dimensions which match the source filter so they can be used to generate a filter on the target model queries.

To support filtering on the linked dimension's (e.g. 0GL_ACCOUNT) hierarchies:

1. Make sure to update the BW queries to activate a hierarchy by default for each of the linked dimensions (e.g. 0GL_ACCOUNT). It does not matter which hierarchy is active by default, just that one is active by default.
2. After the BW queries are updated edit the "Link Dimensions" in the following way:
      - Edit the link.
      - Remove the 0GL_ACCOUNT dimension from the "Matched Dimensions" section for both models.
      - Recreate the link for this dimension by selecting the 0GL_ACCOUNT dimensions on both sides again.
      - Hover over each dimension link checkmark or access the ellipsis (...) menu for one of the dimension tokens and ensure that the "Link on Matching Hierarchies" option is turned ON.
      - Note: This procedure may need to be repeated for all linked dimensions with hierarchies which currently do not have a hirarchy active by default but user desires to filter them on a hierarchy.
    
   After these updates to the "Link Dimensions", any filter on the 0GL_ACCOUNT dimension (using "Flat Presentation" or a hierarchy) should be considered a filter on a linked dimension and propagating filter changes should be able to use the optimal direct propagation workflow which should not perform the performance intensive queries they currently do.
    
   Important Note: Any stories which need to filter on 0GL_ACCOUNT or another similarly updated dimension using "Flat Presentation" have to be converted to Optimized Design Experience (ODE) to avoid performance impact on how those filters are propagated.
     - The Optimized Story has an enhancement where "Flat Presentation" filters for a dimension that has a hierarchy active by default are processed using optimal direct propagation. 
     - This should eliminate any negative performance impact of activating a hierarchy by default which is necessary to fix performance for stories which filter the 0GL_ACCOUNT or other similarly updated dimensions using a hierarchy.

c4a, hyper link, blank, missing, not expected , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem