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?

@Aman Jain-Oracle , I cannot find any instructions on how to install the browser extension/plug-in after download. Please help. I am on Windows 11 and I usually use Firefox, but also have Edge and Chrome available.

If all parts of your formula are Integers, you will get an Integer value. To fix in this case, multiply the left-most value by 1.0 — this will ensure the whole formula. If you put the 1.0 multiplier at the end, it may not work as intended.

Hi image237, Do other views display decimal for SPI(t), such as table or pivot table veiws? If not, what formula are you using for SPI(t)?

If you are using the BI Administration Tool for your data modeling, you can create multiple logical table sources within one logical fact table. Whichever logical table source fits the granularity of the analysis will be used for running the analysis. For example, if one table source includes a mapping to both Ledger…

Themis, In all my years using various versions of OBIEE or OAS, it has been my experience that Count(Distinct ) results show a decimal place, and that the default format had to be changed in this way. Perhaps someone had already set the default format for your columns in OBIEE 11g and now that you are in a new system, it…

Themis, While you are on the Data Format tab, can you see a button called "Save as Default?" If yes, then follow these steps: Select the 'Override Default Data Format' checkbox. Change 'Decimal Places' to 0. Click Save as Default button to open a pop-up menu. Select 'Save as the system-wide default for "your column".'

Hello JPorisVU, Are you able to run and download snapshots? If so, I recommend following these steps: Run a Custom snapshot with all optional content deselected Download the snapshot Open the snapshot's local download in 7-Zip or other archive extractor Open the content folder Select the catalog folder and choose the…