linked pivot tables

[Assaf_Attas]

hi,

i have an excel pivottable connected to a sas OLAP cube

i am trying to create multiple pivot tables that are linked to each other so that the user will select the filter once and that it will effect al the linked tables

 i find it difficult since sas AMO does not support slicers

any ideas guys?

[EyalGonen]

Hi @Assaf_Attas 

Since you asked in English then I will reply also in English 🙂

I think you better post your question in this community: https://communities.sas.com/t5/Integration-with-Microsoft/bd-p/office_analytics as your question is specific to AMO so you would be better off there. I think the answer also depends on the AMO version you use please indicate that as well. The newer version of AMO support making use of Excel PivotTables: https://video.sas.com/detail/video/5978114907001/version-8:-interacting-with-sas-data-in-a-microsoft...

or at https://communities.sas.com/t5/Ask-the-Expert/Using-Microsoft-Excel-PivotTables-in-the-SAS-Add-In-fo...

Eyal

[arielbud]

היי אסף,

מצאתי את ה-Note הישן הזה https://support.sas.com/kb/44/874.html , האם לזה התכוונת שאמרת ש-Slicer לא נתמך עם AMO ?

לפי ה-documentation אתה אמור להיות מסוגל ב-OLAP Analyser לעשות slice

https://documentation.sas.com/?activeCdc=amodoccdc&cdcId=amocdc&cdcVersion=8.2&docsetId=amoug&docset...

לפי מה שראיתי זה אפשרי (צריך להזין יוזר וסיסמה)

 בברכה

אריאל