Categories
- All Categories
- Oracle Analytics Learning Hub
- 25 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Prompt column not bring the all data
Hi,
I have an issue with column that not bring the all data, but when I add it an additional columns it is ok, it seems like a bug.
the issue that I need to bring it alone as a prompt, in the report itself with other columns there is no problem.
Please advise.
Answers
-
Hi,
Maybe you want to start by providing a bit more context?
What product and version?
Did you look at the generated queries? How are they different when the column is alone vs when you have it with the additional column?
Most of the time, you can see this kind of problems because of the source models (in your RPD) and how things are connected etc.
0 -
Obiee version 11.1
It's not relate to the generated queries or the source models (RPD).
Even I create new report base on query of this one column alone vs this column with additional column I got the same result.
0 -
1.) "11.1" doesn't mean anything. A precise and correct version would be 11.1.1.9.190619
2.) The whole 11g family is out of premier support since December 2018 with only 11.1.1.9 getting Bundle Patches until July 2021 but even that has ceased in between
3.) What do the log files say? Exactly.
4.) Your description definitely points to errors in your model but only the queries can tell you anything more
0 -
It's not relate to the generated queries or the source models (RPD).
Sorry but if how can you say it isn't related to the RPD if you have the same behavior when creating an analysis?
If you aren't using a DDR it definitely has something to do with the RPD and how queries are generated.
0 -
Hi,
Thank you in advance for you help.
Acutually in the rpd the specified column come directly from the physically layer without any change.
There is no log details with added value about it since when I add additional column it bring me the all values of this column, but alone I have problem of missing values.
0 -
Not sure how else to say it except: Read the log file. Post the log file here.
If you insist there's no problem, then there's no problem and the thread can be closed
0
