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

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…

Sorry i'm not sure what the Question is then? Is you use say "conitains all" - then wil be displayed as below - you can't change this as that is the functionality of the product

Hi sounds like in the opeator for the prompt you have "contains all" instead of Equal to/Is in. Amend the prompt and change it to what is required

hi i've used your XML and just changed it so it works with our elements/input values and the totals are all correct, so not sure why its not for you. In your pivot table, try changing the aggregation rule to a different option (eg server complex etc) and see if thats fixes it. Other suggestion would be to only include…

hi could you share a screen shot of the current output, what the issue is with it and then say an excel table of what your desired output is? It sounds like you only want to display input values for specifc elements?

I've just updated the same question on https://community.oracle.com/customerconnect/discussion/comment/1236302#Comment_1236302