Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Scorecard Hierarchies: Trend not updating for levels

I've created a scorecard pulling some goals from our dashboards and implemeneted a hierarchy. When filtering down to any level of the hierarchy the trend does not update although the progress value changes for the current days value, so it doesn't seem to be saving the previous values. Is this an available feature or being worked on?  if available why would this be failing to cascade?

 

Metric Hierarchies not working

@v-yanjiang-msft  

Status: Investigating
Comments
Anonymous
Not applicable

Hi @WillR ,

 

Please check if this helps:

Additional considerations for viewing a hierarchy

  • Premium or PPU workspace is required.

  • There are data limits on hierarchies:

    • Up to 10,000 items per hierarchy (across all datasets)
    • Up to five hierarchies
    • Up to five levels per hierarchy
  • Permissions can't be set at a hierarchy level – metric level permissions are set at the scorecard and applied to all hierarchy views.

  • Data connections are evaluated by impersonating the hierarchy owner/creator where row-level security (RLS) may apply. This does not change metric level permissions.

  • Dynamic and static RLS is supported but it is routed through the hierarchy creator. All scorecard viewers impersonate the hierarchy creator’s access.

  • Hierarchy permissions can't be set at a specific hierarchy level. Metric level permissions are inherited from the original scorecard and are applied at all levels, and RLS via the hierarchy creator dictate permissions.

  • Non-admin users may experience refresh issues when setting up hierarchies on a dataset with dynamic RLS.

  • Manual metrics are indicated by an information icon showing which values are manual for that metric.

  • Notifications regarding status changes on child scorecard levels aren't triggered.

  • There is a limit of one selection per hierarchy for viewing a hierarchical scorecard.

  • History for hierarchical metrics isn't supported because data is always queried live from the dataset, instead of cached when the dataset refreshes.

  • Saving and sharing heatmap views isn't yet supported.

Best regards.
Community Support Team_Caitlyn

 

WillR
Regular Visitor

Thanks!