How can you put a total number of records in your oracle OAC table footer
You would have to create a calculation with count(idcolumn) or rcount(1) and drag drop this calculated as a tile and place it below the table viz.
Just another thing that was in OAS not in OAC 😣
Do you mean something that is in "classic" and not in DV? Because OAS and OAC have the same feature for these things.
Are you moving some "classic" analyses and dashboards to DV workbooks and not finding the same exact features?
All I want to do is put the record count in the footer of a table….
User_SYYDG,
If you are adding this "footer" to a table view in a classic analysis, you have two choices:
Image1
Image2
Not using classic
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
