We have this same business requirement. We're currently trying out concatenation through data augmentation then surfacing in the semantic modeler to hopefully improve the performance of our concatenated segments. We were simply just concatenating at the semantic model extensions level and then putting all of those into…

@Benjamin Arnulf-Oracle This is exactly what I'm looking for!

Love the new data visualization and video gallery! It's always great to have examples of new ways to use the tool!

So after the subject area is deprecated you'll see this symbol next to the subject area and the data will come up as a query error. Right click on GL Account Analysis and click replace dataset. Select your new Configurable Accounts Analysis subject area. Next, most of the columns auto populate. Be sure to check each column…

Question on this: Are you looking to use Fiscal Period as your columns or Fiscal Period Number?

Hi @Vinod Menon-Oracle I've worked with higher education and with FDI for almost 3 years now, I'd be happy to chat and share our experiences thus far!

@Victor H Submit a SR asking for budgetary control, then your service admin can enable the feature!

Love this idea, it's very needed!! I see the status says planned, wonder if it's listed in any future release notes.

@Benjamin Arnulf-Oracle I would like it to still show last state, but the true last state of the filter. Watch this video to see the issue demoed. In this scenario it should just remember what is filtered in the Subject Area Dashboard Filter not the Functional Area filter because I remove the selection in that before…

Hi @Oracle Analytics Wizard-Oracle Go to Present Mode, then under the workbook tab select custom under background. From there, you can fill in your desired hex code! Note that in edit mode you won't see your custom header color, however, your when you click the play button you can preview it how your end users will see it.

Hello. I would recommend binding a parameter to your month filter! Start by going to the parameters tab and creating a new parameter: Next, toggle on multi select button, select the column value from the available values, and select month from the drop down. In the initial value drop down, select Logical SQL Query. Input…

Hi there! We encountered this same issue in the past. Here's a forum post I created about it. We created custom dataset then joined it to Workforce core on person number. This is the query we used: SELECT "HCM - Workforce Core"."Basic Information"."Person Number", CASE WHEN COUNT(DISTINCT "HCM - Workforce…

Not sure which subject area you're using, but using Workforce Core I was able to successfully get the current and future 4 years using the following expression filter: "HCM - Workforce Core"."Time"."Year" >= YEAR(CURRENT_DATE) AND "HCM - Workforce Core"."Time"."Year" <= YEAR(TIMESTAMPADD(SQL_TSI_YEAR, 5, CURRENT_DATE))

Does the column Manager User name exactly match the value in User Name? For us, for example, Manager user name column is like "Blanchard, Caroline" versus Display Name column is "Caroline Blanchard". We had to use a custom calc to flip things around because the match has to be exact. What do you mean use it directly, like…

Hi @JT_DC_2023, our organization has successfully used parameters to create dynamic filters of the logged in user using the binding parameters feature. What we did was put in a filter from the out of the box data for example, Display Name out of workforce core and bound to the out of the box parameter Display Name. This…

@Roelof de Groot In the use case you mentioned above, I'd recommend using binding parameters across the dashboard filters on separate canvases. If you have a dashboard filter across three canvases you can bind it to a parameter and if the end user changes the value, it will change in the other canvases as well so long as…

@Matt Milella-Oracle @Jamie Anderson-Oracle This is exactly what I was looking for!! The documentation example is very helpful. Thank you so much!

I second this idea, this is something we need at our organization as well!

Logged an SR about this issue and it was solved. Basically, if your tile metric has a description in there it will cause the stuck in top row issue. To fix it you go into your custom calculation and delete the description. If using an out of the box calculation that has a long definition, you'll have to create a custom…

@Krishna Prasad Kotti-Oracle Bringing in all the values of the custom column (in this case 4 or 5 values maximum) is exactly what I want it to do.