Hi All,
Am having performance issues in OBIEE, in order to optimize BI server query what are the best approach i need to follow to get optimal query .
Just mention what all i need to follow.
Thank you so much for your responses
Try the below approaches:
1. Avoid complex derived measures/attributes in BMM layer of BI RPD, rather try to use physical mappings for logical calculations.
2. De-generate Dimensions should be developed on top of the same fact alias with which join is established.
3. Avoid complex/cartesian joins as it affects performance.
After these, Check latency in the server query. If the delay is more, it means your RPD design/model needs to be revisited.
Thanks,
Kamna
2844292 wrote: Just mention what all i need to follow.
Hi,
If you mean that you are looking for which parameter to change and what setting to do stop right now as this is probably the worst thing to do when you have "generic" not better identified performance problems ....
First (second and third) activity is to find out what does mean "performance problem", based on what do you say it's a problem, what are you comparing with, why do you say that the problem is with OBIEE?
Have a look at this https://www.youtube.com/watch?v=0W34l2O9GMo or read the slides here No Silver Bullets - OBIEE Performance in the Real World (Oracle Open … .
Once you identified what the real issue is you can then ask how can you improve/solve/avoid that particular issue ... But "performance problems with OBIEE" doesn't mean absolutely nothing because of the number of involved processes in a single OBIEE analysis ...
Kamna wrote: 2. De-generate Dimensions should be developed on top of the same fact alias with which join is established.
Degenerate dimensions don't need joined fact aliases and can be built directly on the same physical object as the logical fact table itself. Just sayin'.
Yeah, but I have seen folks developing degenerate Dims on top of the same fact but with different Dim - Fact alias and try to treat it as Degenerate Dim. This leads to self join and hampers performance
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
