SAC Usage dashboard ACTIVITY_LOG model - how to include Week level to "Date" hierarchy

[former_member865568]

Level 4 is 'Month' and Level 5 is 'Day'. I want to add a 'week' level to the hierarchy. The "Week" data exists in the model but is not currently included in the hierarchy.

I tried to create an Excel file as a calendar file and link it to the ACTIVITY_LOG model, but the widget doesn't show the data.

[JefB]

Hi Yuting,

Not possible using hierarchy, because you cannot adjust any hierarchies on this live SAC ACTIVITY_LOG model (it's controlled by SAP only).

You can however add the week property as a dimension in rows like this:

[sharonzhou]

Hi Yuting,

You may use the "flexible time" concept in SAC to address your question. Here is the documentation that could be helpful for you. https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/6a22f9081ab540acb9e2c...

BR,

Sharon