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.
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
