BookmarkSubscribeRSS Feed
nikwes
Calcite | Level 5

What is the best practice to organize data objects in VA for re-use of shared data objects ? Is there a 3 tier or layered architecture or best practice?

The objective is to define once and reuse the same definition across multiple reports / analyses. I need to understand what good/best practice there is to 

- map facts & dimensions from a non SAS DW Kimball star schema to a SAS Object model

- Define Business Terms on top of the imported facts and dimensions

- Define KPIs, Derived KPIs  using Aggregate functions and summarization rules (SUM, AVG...) on top of the base facts 

- Define custom dimensions not found in the DW

- Reuse these definitions in reports 

 

something along the lines of my illustration below ?

nikwes_0-1720442542389.png

 

What I want to avoid is individual reports with different definitions of KPIs, Derived KPIs, Custom Dimensions

Can anyone help with documentation and SAS vocabulary so it is easy to explain to my fellow developers?

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 271 views
  • 0 likes
  • 1 in conversation