Question: How we are going
to decide which schema we are going to implement in the data warehouse? Answer: One way is what is mentioned in Question
above. If you ask me to blindly create schemas for the warehouse without
knowing any requirements, I will simply first divide the schemas on the basis
of functional areas of an Organisation which are similar to the modules in an
ERP like sales, finance, purchase, inventory, production, HR etc. I will
broadly describe the expected analysis an organisation would like to do in
every module. I think this way you would be able to complete at least 40-50 %
of the requirements. To move ahead, study the data and business and you can
create few more schemas.
Question: What are the Challenges You Faced
while making of Reports? Answer: Making of an report has never been a
difficult task. But problem comes when users are reluctant to adopt a new
system. I have experienced that if you are not able to create the report in
exactly the way they used to see, they will keep asking for the changes. Your
approach should be to first show them what they want to see and then add more
information in the report.
Question: What you will do
when your Report is not Fetching Right Data? Answer: this is the biggest problem in report creation and
verification. There could be two reasons for report not fetching the right
data. 1. Mostly clients do not have correct data in their database and on top
of that to correct the results they make some changes at the report level to bring
the desired result which you may not e aware of while creating the reports.
Clients try to match the data with their existing reports and you never get the
correct results. you try to discover the things and at later stage come to know
of all these problems and you are held responsible for this delay. Hence always
consult the SPOC(Single Point of Contact) and try to understand the logic they
have used to generate their reports. 2. If the database values are correct,
there there could be a problem with the joins and relations in the schema. You
need to discover that analysing and digging deep into the matter. There are
more questions which I will try to answer later. The questions are very
specific to OBIEE and I dont have much experience in that. Hence you may not
agree to my answers, but wherever please post a comment and let me know too.
Question: How analytics
Process Your Request When you Create your Requests. Answer: If the Question
means how does Oracle BI Analytics Server processes the user requests, the
answer is- Oracle BI server converts the logical SQL submitted by the client
into optimised physical SQL which is then sent to the backend database. Also in
between it performs various tasks like converting the user operations like user
selections to form a logical SQL, checking and verifying credentials, breaking
the request into threads(as Oracle BI is a multi threaded server), processes
the requests, manages the cached results, again
converting
the results received from the database into user presentable form etc.
Question: From where u Get the Logical
Query of your Request? Answer: The logical SQL generated by the server can
be viewed in BI Answers. If I have not understood the question, Please raise
your voice.
Question: Major Challenges You Faced While Creating the RPD?????? Answer: Every now and then there are problems with the
database connections but the problem while creating the repository RPD files
comes with complex schemas made on OLTP systems consisting of lot of joins and
checking the results. Th type of join made need to be checked. By default it is
inner join but sometimes the requirement demands other types of joins. There
are lot of problems with the date formats also.
Question: What are Global Filter and how thery differ From Column
Filter? Answer: Column filter- simply
a filter applied on a column which we can use to restrict our column values
while pulling the data or in charts to see the related content. Global filter-
Not sure. I understand this filter will have impact on across the application
but I really dont understand where and how it can be user. I heard of global
variables but not global filters.
How to make the Delivery Profilers Work? When
we are Use SA System how Does SA Server understand that It needs to use it For
Getting the User Profile information?
Where to Configure the Scheduler? Answer: I am not sure if Iam correct but we configure the OBIEE
schedular in database.
Question:
How to hide Certain Columns From a User? Answer: Application access level
security- Do not add the column in the report, Do not add the column in the
presentation layer. Question:How can we Enable Drills in a Given Column
Data? Answer: To enable Drill down for a column, it should be included in
the hirarchy in OBIEE. Hyperion IR has a drill anywhere feature where dont have
to define and can drill to any available column.
Question: Is Drill Down Possible without
the attribute being a Part of a Hierarchical Dimension? Answer: No
Question: How do u Conditional Format.? Answer: while creating a chat in BI Answers, you can
define the conditions and can apply colour formatting
.
Question: What is Guided Navigation? Answer: I think it is just the
arrangement of hyperlinks to guide the user to navigate between the reports to
do the analysis.
How is Webcat File Deployed Across Environment? Question: How the users
Created Differs From RPD/Answers/Dashboards Level?????
Answer: RPD
users can do administrator tasks like adding new data source, create
hirarchies, change column names where as Answers users may create new charts,
edit those charts and Dashboard users may only view and analyse the dashboard
or can edit dashboard by adding/removing charts objects.
Question:
Online/Offline Mode how it Impact in Dev and Delpoyment???? Answer: Online Mode- You can make
changes in the RPD file and push in changes which will be immediately visible
to the users who are already connected. This feature we may use in production
environment. Offline mode- can be useful in test or development environment.
No comments:
Post a Comment