https://communities.sas.com/t5/SAS-Visual-Analytics/Best-Practice-for-Visual-Analytics-Data-Architecture/m-p/934959#M18121 <P>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?</P><P>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&nbsp;</P><P>- map facts &amp; dimensions from a non SAS DW Kimball star schema to a SAS Object model</P><P>- Define Business Terms on top of the imported facts and dimensions</P><P>- Define KPIs, Derived KPIs&nbsp; using Aggregate functions and summarization rules (SUM, AVG...) on top of the base facts&nbsp;</P><P>- Define custom dimensions not found in the DW</P><P>- Reuse these definitions in reports&nbsp;</P><P>&nbsp;</P><P>something along the lines of my illustration below ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nikwes_0-1720442542389.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/98207i9D8A8059AA4B388A/image-size/medium?v=v2&amp;px=400" role="button" title="nikwes_0-1720442542389.png" alt="nikwes_0-1720442542389.png" /></span></P><P>&nbsp;</P><P>What I want to avoid is individual reports with different definitions of KPIs, Derived KPIs, Custom Dimensions</P><P>Can anyone help with documentation and SAS vocabulary so it is easy to explain to my fellow developers?</P> Mon, 08 Jul 2024 12:49:48 GMT nikwes 2024-07-08T12:49:48Z https://communities.sas.com/t5/SAS-Visual-Analytics/Best-Practice-for-Visual-Analytics-Data-Architecture/m-p/934959#M18121 <P>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?</P><P>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&nbsp;</P><P>- map facts &amp; dimensions from a non SAS DW Kimball star schema to a SAS Object model</P><P>- Define Business Terms on top of the imported facts and dimensions</P><P>- Define KPIs, Derived KPIs&nbsp; using Aggregate functions and summarization rules (SUM, AVG...) on top of the base facts&nbsp;</P><P>- Define custom dimensions not found in the DW</P><P>- Reuse these definitions in reports&nbsp;</P><P>&nbsp;</P><P>something along the lines of my illustration below ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nikwes_0-1720442542389.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/98207i9D8A8059AA4B388A/image-size/medium?v=v2&amp;px=400" role="button" title="nikwes_0-1720442542389.png" alt="nikwes_0-1720442542389.png" /></span></P><P>&nbsp;</P><P>What I want to avoid is individual reports with different definitions of KPIs, Derived KPIs, Custom Dimensions</P><P>Can anyone help with documentation and SAS vocabulary so it is easy to explain to my fellow developers?</P> Mon, 08 Jul 2024 12:49:48 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Best-Practice-for-Visual-Analytics-Data-Architecture/m-p/934959#M18121 nikwes 2024-07-08T12:49:48Z