topic linked pivot tables in SAS Users Group in Israel

linked pivot tables

Assaf_Attas — Mon, 15 Jun 2020 09:25:15 GMT

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?

Re: linked pivot tables

EyalGonen — Mon, 15 Jun 2020 10:21:51 GMT

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-excel-pivottable-with-the-sas-add-in-for-microsoft-office

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

Eyal

הנידון: linked pivot tables

arielbud — Tue, 16 Jun 2020 06:52:36 GMT

היי אסף,

מצאתי את ה-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&docsetTarget=p08iu30djarz29n19dh3emvscoah.htm&locale=en&docsetVersion=8.2

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

בברכה

אריאל