3452903 - Diagonal line would appear on Calculated Measure based on Lookup formula and Previous function defined in model in an Optimized Design Experience mode story in SAP Analytics Cloud (SAC)

• Use the formula Lookup and Dynamic Time Navigation Function "Previous" to define a calculated measure in model
• Create an Optimized Design Experience mode story based on the model and insert a table containing date dimension into this Optimized story
• After drilling down the date dimension to the lowest level, observe that no calculated measure values would appear on the parent node of the date dimension and only diagonal line would appear in these cells

• SAP Analytics Cloud 2024.2.16

1. Log on to SAC
2. Open the sample model
3. Open the Calculations Workspace, add a calculated measure "Lookup" in this model and define the calculation as "LOOKUP([Measure] ,[d/Date]=Previous("Year",1))")
4. Create an Optimized Design Experience mode story based on the above model
5. Insert a table into this story and add the Date dimension as well as Measure "Lookup" (namely the calculated measure defined in model) in this table
6. Click on the three dot graph button beside the table and select Drill to drill down the Date dimension to the lowest level "Level 4"
   => Observe that values of this calculated measure "Lookup" would appear on the Month level (namely the lowest level of Date dimension), while no calculated measure value would appear on the Year or Half-Year level and only diagonal line would appear in these cells

• This is currently a by designed behavior.
• The calculated measure containing function "Previous Year" has "Required Dimensions" set to include the "Date" dimension in the model.
• The "Required Dimensions" list is used to check for the "Minimum Drill" required for data to be shown. As soon as a hierarchical dimension is included (e.g. "Date"), the lowest level of the hierarchy is required to display the data. This can be achieved by drilling or by creating single value filters on the lowest level members. 

• This is currently a by designed behavior.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• Need More Help? Contact Support or visit the solution finder today!

Your feedback is important to help us improve our knowledge base

sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, calculated measure, Diagonal line, date dimension, drill, aggregation , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem