Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
After upgrading from 11g to 12c essbase reports shows data different from 11g.
Hi All,
We have upgraded from 11g to 12c. There are so many reports from essbase datasource. These reports shows data different from 11g to 12c. Do we need to anything about configuration?
Thanks
Hari
Answers
-
Hi,
You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ?
Did you do some analysis/debug of the case to find out what is different between how 11g and 12c do things? (generated queries etc.)
Do you talk about analysis or reports (BI Publisher) ?
Did you try building a new analysis from scratch step by step to see if you get to what you look for?
Were your analysis properly done or more using workarounds and tricks to get what you wanted to see?
0 -
Hi,
to paraphrase Gianni you need to cut your problem down.
IT is a bit like plumbing.
When the water comes through a funny colour you need to trace it back step by step.
With admin rights; which is to say no security; if you construct a simple query against pre / post subject area do you get the same data?
Then apply security and check like for like?
Then look at what security has been ported for Essbase, is it identical?
Then reconstruct one of your existing reports from scratch, do you get the same answer?
If you compare the report constructed in Smart View running directly against Essbase do you get the same answer?
The world is like a mountain of manure if you want to move it you have to do it a handful at a time. (Sllightly cleaned up version of a Beat Poet's sentiment)
0 -
You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ?
Answer: They are not correct
Did you do some analysis/debug of the case to find out what is different between how 11g and 12c do things? (generated queries etc.)
Answer: 11g is showing a crossjoin between the applied filters
Do you talk about analysis or reports (BI Publisher) ?
Answer:Analysis
Did you try building a new analysis from scratch step by step to see if you get to what you look for?
Answer: I see the data that shoudn't show in 12c. But 11g reports has data that is not correct. We are planning to connect with users about this.
Were your analysis properly done or more using workarounds and tricks to get what you wanted to see?
Answer: Yes. We tried
0 -
with admin rights; which is to say no security; if you construct a simple query against pre / post subject area do you get the same data?
Answer: Haven't tried this. I am new to essbase.
Then apply security and check like for like?
Answer: Security is applied via shared logon in 11g and where we kept static name for 12c in connection pool properties. But testing team using the same login that we applied in 12c.
Then look at what security has been ported for Essbase, is it identical?
Answer: Yes! Its identical.
Then reconstruct one of your existing reports from scratch, do you get the same answer?
Answer: I am not getting what 11g is displayed. I believe 11g is not correct. Need to confirm with the users how did they approved this report.
If you compare the report constructed in Smart View running directly against Essbase do you get the same answer?
Answer: I dont have the credentials currently. Will try to check.
0 -
'I see data that shouldn't show in 12c' - is it possible that in 11g you had applied additional filters at the physical or logical level to limit what was passed through to the reports?
0 -
3695178 wrote:You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ?Answer: They are not correct
Still doesn't mean anything at all. Does that mean that you get different numbers in the OBI Analysis compared to what's stored in the cube?
Have you checked the MDX? You HAVE to look at what is being emitted as a query against the cube in detail!
Also: In my experience 99% of such problems are due to wrong usage and especially imprecise old configuration migrated from 11g.
0 -
This is why I was asking if they could compare Smart View versus OBIEE then you are comparing with an objective benchmark.
0 -
Yes! its strange..Everything is similar. But Query execution is different from 11g vs 12c. We will confirm with users once.
0 -
Why with users? Look at the raw data. Look at the queries. Look into the cube.
0 -
Amen to that.
If I want a lot of sound and fury signifying nothing I will consult an end user.
If I want the objective reality I will look at the data.
0
