Pivot Table Prompts Duplicating Values
I'm trying to replicate a report from old Oracle Discoverer to OBIEE.
The issue is that when I had the "pivot table prompts" to the OBIEE analysis. I'm left with duplicates instead of unique values in the drop down field. Can anyone explain how I can keep this from occurring? This only happens when I add three or more attributes/columns to the "pivot table prompts" section. This worked in Oracle Discoverer….
Be sure, for the physical connection you have defined, that you have checked the below option:
Also, I know there was a bug around this sort of functionality occurring if the column properties were set to repeat, but that is not a common thing people do, and is probably not your scenario, but it is worth a look: Bug 13147411 : 11G PROMPT IS DISPLAYING REPEATING VALUES WHEN ITEM PROPERTIES SET TO REPEAT
As mentioned by rmoff, incorrect keys can often lead to this issue. As he said, you can check the nqquery.log to see the physical SQL, or enter SET VARIABLE LOGLEVEL=4; in the SQL prefix on the advanced tab, then run your report again. This will generate a log in the admin pane of the tool that you can check easily.
- Duplicate key error after adding data in a table with seeded entities
- Get count of id for each day and Group by date
- How can I replace a string in a MySQL database for all tables in all fields in all rows?
- Run sql file in database from terminal
- What is the best way to do incremental backups in MySQL?
- How do I set MyISAM as default table handler in MySQL?
- Sequilize query is returning only one row while using include
- MySQL Error: #1142 - SELECT command denied to user
- MySQL Not Equal To Certain Length
- How to disable secure_file_priv in MySQL 8.0 in windows 10 machine?
- Php mysql query update of data gives syntax error
- How to retrieve a lot of data in my asp .NET app efficiently?
- Update an existing sql table based on content from an external csv file?
- Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How to connect from VSCode to a mysql docker container?
- SQL syntax error when trying to create a new table using TypeORM
- How do I convert text entered in form to Title Case Using PHP before submitting to MySQL?
- How to declare a variable in MySQL?
- MySQL Paging and Return Total
- How to drop columns in a table, where column names are "index" and " Unnamed: 0" in mysql
- How to deal with enormous line lengths created by mysqldump
- MySQL union - alias not visible
- Join newest price from price-table for all products
- Mysql ERROR: ASCII '\0' while importing sql file on linux server
- User registration with CodeIgniter
- Paging Results: Handling invalid passed data
- I'm stuck with foreign key constraint fails error. .NET 8, EF Core 8.0.2
- find number of rows in returned mysql result (nodejs)
- Get records that have total count of over X amount