Here is my calculation
CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
Hi @User_SYYDG
@Chere-Oracle is correct that you can only add a fact/measure in a tile.
The way I would achieve this is to use just COUNT(SAAR_ID) as the Fact and label it Pending SAARs and add it to the tile.
I would then use a custom description for the tile and use the Current Date Time Parameter in there. I have something similar in one of my workbooks @parameter ("Select Fiscal Period")('') Actual Which returns as '07-21 Actual' when I select that period.
Dan
Hi User_SYYDG,
What interface are you using — classic analysis or DV workbook?
I have no experience using the Tile in a DV workbook, but maybe my experience with classic analysis will help.
In an analysis, a Tile will only work when the column is treated as a measure. To get your character string output to be treated like a measure, set the Default Aggregation rule field (to something other than 'None') in the column formula. How the aggregation rule may effect the Tile result depends on the level of granularity in your Select results. I like to use Min, but my Select statement returns only one row.
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…
