Is the list of values static, or does it frequently change? If static, you can use Specific Column Values instead of SQL Results. If you have Data Visualization, you can use a DV Dataset as though it is a subject area. You can upload the list as a file to DV, which will become a Dataset. Or maybe you can create a direct…

Yes, GT86, I mean columns in a subject area. :)

Hi GT86, You cannot do a direct database query within the dashboard prompt. If you use the SQL Results option, it has to be a logical query. Do you have any presentation columns that contain the values that you want to show in your choice list?

Hello GT86, Here are two sample conditions that use presentation variables: nvl(org.ORG_NAME, 'NULL') in (@{TS_Org.isAllColumnValues?NULL:TS_Org}['@']{nvl("ORG"."ORG_NAME", 'NULL')}) requests.REQUEST_TYPE in (@{TS_Type.isAllColumnValues?NULL:TS_Type}['@']{"REQUESTS"."REQUEST_TYPE"}) There are 4 things you should notice:…

The column was already defaulted with 'Repeat' option as below. Hmmm… Saving as the system-wide default has always worked for me, but I have not encountered an example that already had the desired setting as the default. However, i tried saving as you mentioned. There is no change to the behavior. You might try picking…

You should be able to use a logical SQL query for your dataset. If you built a union query in classic Answers, its logical SQL can be copied from it and then pasted into a manual query in DV. Instead of pulling the subject area into your dataset, pull "Manual Query" into the dataset and paste the logical SQL into its…

All the columns are suppressed by default. Hi Bala.01, I have 2 questions: Is this pivot table a DV Visualization, or is it a view in Answers? From where are the columns being pulled — from an uploaded file or from a subject area? Columns from subject areas can have their default properties changed if done in the Criteria…

https://community.oracle.com/products/oracleanalytics/discussion/comment/74650#Comment_74650 Well, it did work for a while, then I began getting the same error message again. I will try the original solution, which was to write multiple datasets and unite them in the analysis or workbook.

https://community.oracle.com/products/oracleanalytics/discussion/comment/74613#Comment_74613 Thank you, Brendan! It works very nicely to split the single filter into two, then union the two filter results together within the same data flow.

@Subhakara Netala-Oracle What did you finally do to resolve your problem? I am experiencing the same issue.

How often is the manager hierarchy data updated? Does the data expected to include historical, or only current?

If you can download and install the Catalog Manager version 7.5 or lower, and if you can download a Snapshot and extract the \content\catalog folder using an unzip utility, then you can use Catalog Manager 7.5 to open the extracted catalog offline. From there, you can use the Tools > Create Report command to pull the ACL…

Hi @User_TTHXA , In OAC you can download a list of users, direct and indirect, for an application role in the following way: From the Console, go to Roles and Permissions. Select the Application Roles tab. In the left-hand column, select the desired application role. In the right-hand column, select the Members tab and the…

Tim, My only guess is, perhaps the join to your DV workbook is causing duplication of some rows from the subject area, so that the decimal places become more significant than without the join. If the decimal places are of no significance in OBIEE but are more significant due to the join in DV, this may be why your SUM=0…

Tim, So, if you are not converting them to Integer during the calculation, or converting the sum to an Integer, they are definitely returning a non-Integer sum. It may look like an Integer, but it has unseen decimal places.

Tim, You write as though the two fact columns are Integer data types to begin with, but you have not actually verified it. The calculation may appear to be returning Integer when the sum is actually a rounded double precision or floating point. Have you verified that the facts have an Integer data type? It could be that…

Hi Tim, I am guessing that Expenses or Income, or both, is not an Integer, so one or both of the values is not truly 100. My suggestion is to convert them to Integer data type for your calculation, like this: CAST(Expenses AS Integer) + CAST(Income AS Integer) Otherwise, you can change the calculation to round the sum,…

Hi Tony_OAL_Apex_User, Yes, but why did you make the text box prompt as a Presentation Variable? Why not create a normal column prompt for a prompted filter, changing the prompt's User Input setting to 'Text Field'?

Hi Tony_OAS_Apex_User, Why did you make the text box as Presentation Variable? I presume it is a column prompt, rather than a variable prompt. Will its column formula not work with a prompted filter's column formula?

Please show a screenshot of the prompt's settings. How are you filling in the prompt values, 111234 and 111234A?