@Krishna Prasad Kotti-Oracle As stated above, logical SQL does not work when referencing another parameter in the logical SQL.

That worked for me thank you

@fbarazan-Oracle If I choose 'Column' under available values I get a list of values pertaining to the subject areas in the report. Also you have to have a value under initial value. Did your parameter save like that??

So what I'd like to do is take that previous date calculation you have there and put it into a parameter, similar to the out of the box parameter 'Current Date'. The reason for this is we'd like to have a little box that shows what date they can expect their data to be updated through. For us, the daily refresh runs…

Hi @David Saggioro! This use of the binding parameters works to get the right selection into the filter, however strangely no data shows when its used. After binding the parameter, the person display name is properly selected, but it doesn't work to filter the table, and all other names in the list no longer show. Any…

This is a capability also needed for our team as well. @Krishna Prasad Kotti-Oracle The reason the Logical Query Source Path doesn't work is because the canvas information does not show the name of the canvas after you've renamed it, but rather canvas 1, canvas 3, etc. As you can see here, we can only see Canvas 6, but in…

Any updates on this @Ramamurthy Shankarachetty-Oracle, @Sumanth V -Oracle, or @Mallikarjuna Kuppauru-Oracle

@Krishna Prasad Kotti-Oracle Just month name! In the top visual there's data from the current year and the previous year so I just want to compare things on a month basis. Basically, I'd like to keep the attributes the same (eg fiscal period number) and have the option to simply reformat the axis to show month name instead…

@Laura Bachiller I opened a SR about this and was told to just recreate the canvas from scratch, so no solution to this issue.

Hi @Krishna Prasad Kotti-Oracle , We cannot remove the duty roles as we need them for securing our custom built reports. We need an option to remove the back button so that users do not end up on the homepage looking at reports we did not intend them to look at.

Hi @Sumanth V -Oracle , We are looking to expand the XCC hierarchy in the preview subject areas Budgetary Control Balances and Budgetary Control Transactions. We would like to configure the XCC segments to add in information like Fund (known as Third Balancing Segment in the general ledger). Can this be configured?

Hey Rachel! We had the same drill down need for leadership staff and we were able to solve it using data actions. We set up the data actions and anchor them to specific data or visualizations and link them to different reports we've created the drill into more detail. You are even able to pass all values or specific values…

This is a highly requested feature by our users, this would be very useful! We would love to see this default customization for FAW/FDI as well.

We created a custom dataset to do this. Here is the query we used: SELECT "HCM - Workforce Core"."Basic Information"."Person Number", CASE WHEN COUNT(DISTINCT "HCM - Workforce Core"."Ethnicity"."Ethnicity - All") > 1 AND "HCM - Workforce Core"."Basic Information"."Person Number" IN (SELECT "HCM - Workforce Core"."Basic…

Hi @AnishaPatra-Oracle your example looks like what we are looking for! It would be fine to be a custom DFF or just a new attribute in the HCM Subject areas such as workforce core.

That would also solve the problem!

It does not return the expected value @Mallikarjuna Kuppauru-Oracle . Thanks for getting back to me so quickly!

Hi @Shantaram-Oracle , can you drop your email so I can send you a screenshot directly?

This is a great idea! Especially for columns with suppressed repeating values, if enough are suppressed it looks like there is no data in the cell. Perhaps a top and bottom justification could also be helpful.

I've experienced this issue as well, I wonder if there's any update on this...