Hi Steve All deployments look fine including the one you mentioned. 

Hi Steve. I do have an open SR and have had no response in over 24 hours so I thought I’d reach out to the community in parallel. Regards Joel

I'm sure you're aware but for completeness, the Oracle Analytics ideas forum has been available for some time now.

https://www.oracle.com/solutions/business-analytics/analytics-for-applications.html As far as I'm aware, Oracle Analytics for Applications is a service which you subscribe to in addition to Oracle Fusion Application Services…

Can you try simplifying your treemap viz to see if that makes a difference? I don't have any issues with treemaps in the Narrate view. Can you also check if there are any errors in the console > sessions.

Not very clear here what you are doing. Can you provide a few more screenshots to help explain what it is that you're doing?

Have you taken a look at the Manage Color Assignments option in Oracle Analytics? https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/apply-color-visualizations.html

There was mention of an idea lab on CCC for this purpose at the Oracle Analytics Summit earlier on this year but nothing else has been mentioned since then by Oracle.

Have you got a copy of the tnsnames.ora file in the right location for your 12c Admin Tool? https://support.oracle.com/knowledge/Enterprise Performance Management and Business Intelligence/2068474_1.html

Hello Juan Miguel Is this the same as - https://community.oracle.com/message/14885807#14885807 ? If so, you'd need to enable the CSV output option - https://docs.oracle.com/middleware/12213/bip/BIPRD/GUID-BBB60FD1-06A8-42BA-BD41-B351BD0B4816.htm. The document lists out how to enable this and what the limitations are.

You haven't specified which version of OBIEE you're running by the way as this has some impact on where these settings can be found in Enterprise Manager. If you're on OBIEE 12c, then open up Enterprise Manager, Click on the Target Navigation icon and select and expand Business Intelligence and then right click on…

Have you looked at the plug-ins in the Oracle Analytics Store? There is a Collapsible Tree Plugin which may meet your needs

Select your date in the Data Elements section as ​ mentioned, change the Data Type (if required) then the format in the properties section by clicking Custom and changing the format mask as you require.

This thread has been answered so you need to create a new thread if you'd like anyone to look into your issue.

What is the error you're getting?

and when you run the query that is in the obis1-query.log file directly on the database (TOAD,SQL Developer), do you get the correct results?

is your OS 64 bit?

I wouldn't be surprised if it doesn't work. The Mac OS version of DVD doesn't have a full set of functionality when compared with the windows version. Only options are to either run DVD on Windows natively or on a Windows VM on your Mac.

Take a look at this: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsam/getting-started-administration.html#GUID-C351C3A9-0F88-4C1C-…

Oracle Support Document 2167518.1 (BICS How To Personalize The Oracle Business Intelligence Cloud Service Logo) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2167518.1