oracle-databasebusiness-intelligenceoracle12cobiee
OBIEE 12.2.1.2 - Narrative repeats referenced value
I am facing problems with narratives in the latest OBIEE release (12.1.2.2).
For some reason narratives are displaying the referenced values more then once. Additionally other referenced values are ignored (i.e. 15,16,17,...). (There are no restrictions, filters, ...).
See picture:
Ideas and suggestions are much appreciated!
Solution
a) 12.2.1.2 b) Narratives display data precisely at the grain of your query. So if you have other columns in your criteria which force the grain to a lower level and hence force your attribute to repeat....you will get repeated values.
- Orcale SQL select next and previous 3 rows of a specific row in groups
- Oracle SQL developer error: could not install some modules
- How to exit sqlplus when error happens
- What is the difference between -Xss and -XX:ThreadStackSize?
- EF query to Oracle throwing "ORA-12704: character set mismatch"
- Load data to remote DB using sqlldr
- Oracle ORDERED hint cost vs speed
- Oracle Merge Statement Raises "ORA-02012: missing USING keyword" Error
- How to debug a SP response in Quarkus using EntityManager
- How to avoid variable substitution in Oracle SQL Developer
- How to use Function inside of MERGE USING clause in Oracle?
- ORA-01861 Error When Trying to Create WHERE Date is 6 Months From Current Date
- Identify the content type within a BLOB field
- Does Connection pool also closes associated Session on the Database?
- Is it possible to use GROUP BY with bind variables?
- How to insert an "Optimizer hint" to Hibernate criteria api query
- Spring boot with Oracle AQ and Universal Connection Pool
- SQL/Oracle: Is it possible to have a group function in a check constraint?
- With python-oracledb what does 'DPY-4027: no configuration directory to search for tnsnames.ora' mean
- Return multiple ref cursors in single OUT parameter of stored procedure
- Creating triggers with table referencing
- Does Oracle have an equivalent of SQL Server's table variables?
- Oracle: What does `(+)` do in a WHERE clause?
- Oracle database 19C, In SQL query how to compare '["a", "b"]' = '["b", "a"]' is TRUE
- How to treat MAX() of an empty table as 0 instead of NULL
- Optimizing OLE DB Destination for Fast load from Oracle to SQL Server for SSIS
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- Update statement using with clause