Hi Suzanne Gill-Oracle/Mostafa Morsy-Oracle, Thanks for your response.I have tried TOPN and Rank function .TOP N is working fine for single customer. But in my case i have multiple customer whose data exists for 13 week.I have to find for best 10 week values out of 13 week for each customer and then show the avg for each…

which report you want to burst - BIP report ?

This feature is needed.

Yes you can do it in same data model. You have to create 2 bursting definition one for email and other for FTP. But you have to create 2 reports to do that because one support only one bursting definition.

Anyone knows this is mark as delivered .

Thanks Gabby Rubin-Oracle.

Thanks Gabby Rubin-Oracle . I will check and Slack to Avinash for any issue.

I have tried .We can achieve this scenario by use of parameter where we can use logical sql query with order by condition. In order by condition we can use case statement.

This can be achieved by help of Parameter .

Yes You can close the Idea.

I found one solution were this scenario can be achieved. First Create Month Year Column by using below Logic : MONTHNAME("Date") || ' ' || CAST(YEAR("Date") AS CHAR) Create one Numeric column called DateSort for Sorting in Graph. min(EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ),Date", 'YYYYMM')) Go to any Graph then under…

Did you try to use Aggregate as Sum and By column All values or set of Column name.

Thanks @Avinash Krishnaram-Oracle for your confirmation.

Any option or workaround to do this.

Yes format option should be needed to choose custom format based on business need like if business want to show the reports only in (M).

Hi Ajay, You can create free tier account and provision OAC there. https://www.oracle.com/in/cloud/free/ then follow the below link to start with OAC beginner and Handson. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsgs/what-is-oracle-analytics-cloud.html#GUID-E68C8A55-1342-43BB-93BC-CA24E353D873

Any comment on this issue.

I don't see any option where we can enable 'Developer' on the Oracle Analytics Desktop version. Because Oracle Analytics Desktop we do not have any user profile as such.

Hi SteveF-Oracle, Thanks for the update. Yes i have cheeked it .

Yes ,Guest access is not supported when Publisher uses a shared catalog or is installed with Oracle Analytics Server. Guest access is not supported with Single Sign-On. Option is not coming . Standalone i will come.