ah yes sorry i misunderstood the initial question….not sure if that is achievable then

hi yes …so just try the same solution as for analytics - removed the pod info…. i don't know if this will work or not but its worth a try

hi no process im aware of - its instantaneous for me - ie set a SA to "deny" > create new analysis > SA now not visible. I have all the top level roles too - admin, integration ,security manager etc and the "deny" works for me. Sorry, not sure what else to suggest

I have BI admin and cant see it once denied - thats what we do for all the SAs that we dont use…just try it out…presume you have test envs

Hi - its works for me - try clearing your browser cache etc I can only see what has been granted

hi you need to go to Admin> Manage priviledges - if you dont have this option, you need to get the BI admin role. Once there. just set the permissions as required…. If you want to hide a SA area for everyone, say because you don't use that Module, just change the permissions to denied

Hi we had similar requirement for a tile link to analysis. Solution was to remove the POD info from the URL eg instread of https://<yourpod>/analytics/saw.dll?….. change to https:../../analytics/saw.dll?…… then don't need to change during P2T See if that works for you

https://support.oracle.com/support/?kmContentId=2721576 on here too https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

few hits on that too…try this https://community.oracle.com/products/oracleanalytics/discussion/19847

Have you searched the forum? https://community.oracle.com/products/oracleanalytics/discussion/23294/

@Nathan CCC does that meet the requirement though? A mandatory prompt doesn't stop the query from running , it just means if there user is going to enter any prompts that one is mandatory? eg prompt is mandatory but all results are initially returned

hi - another way is just to set one of the prompt values to a value that doesn't exist. eg say one of your prompts is for person number, then in the analysis, you probably have a filter "Person number is prompted" - change this to say "Person number = xxx", then when the dashboard opens - it will open with no data as "xxx"…

Hello- can you not get all that info from the one "Assignment real time" subject area? (You should try and just use one if possible -avoids aditional joins which could maybe then result in aggregraiton issues ). If using the Person subject area for "person count" - just create your own in the Assignment SA -…

Nathan re: Effective dates - this is the issue with Global transfers - the old pre-transfer record is still active (end date 31/12/4712) - which is why both records then get returned - they are both "current" so nothing to do with changing the session variable etc. Oracle provide the GT functionality but we've had so many…

Yep mandeeps solution works. Can also use a subquery to achive the same: Create a report whch will be used as a subquery report which returns the person number and max(assignment number). - so that will return "E1-2" Then in you main report add a filter on assignment number and reference the Max assignment number in the…

Can't you just add a filter : Assignment Status = Active - Payroll Eligible then will just pick the current record and not the previous one that is now inactive?

hi yeah sorry not sure what issue is with your data then. A union could be the answer. So if your current query is working - just do a union and combine it with the same dimensions/measures for the other elements and see if that gives you the answer… If there is say a dimension in one union that isn't present in the other,…

Hello, i didn't save my query…. Just recreated and the Bonus total was incorrect this time So changed the aggreation from "default" to "sum" and its now correct XML attached https://us.v-cdn.net/6037859/uploads/01CHQR3PBEJ9/element-xml.txt

So you want to enter an account value in a prompt and then return whatever segment it is in? If so this should work : Create a prompt and under prompt options - set a presentation variable eg AC_VAR. Then in your analysis, add a filter for each level and set it to the PV Level 22 value is equal to (presentation variable)…

If you have amended the formula in your analysis - you just need to make the formula in your prompt exactly match. So if analysis formula is say: Case when "Account" = '11111' then '99999' else "Account" end then make the formula in the prompt the same. If thats not what you mean can you provide more detals please ie what…