Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
New questions will be added regularly so keep Visiting the blog for updates.
OBIEE Interview Questions And Answers
I.Introduction:
1.What is the end to end life cycle of OBIEE?
2.what are the type of obiee 11g installations and port configurations.
3.what are the obiee 11g components and types.
4.what are the types of tables and columns in obiee.
5.what is schema and types scheme in obiee.
6.what is obiee history and latest versions.
7.Differece between obiee 10g and 11g.
8.what is meant by conformed dimensions.
9.Difference between snow flake and star schemas.
10.What is surrogate key?
11.What is mixed schema?
12.Which OBIEE Versions did you worked on in your projects?
Keep Visiting the blog Updates!
II.Practionser Level:BI Admin Tool(RPD)
A.Introduction:
1.what is use of BI admin tool.
2.what do u mean by metadata and rpd.
3.what are the three layers in rpd.
4.What did a rpd stores and what is it size general and in your Project.
5.What are modes of using RPD?
B.Physcial Layer:
1.what are objects of physical layer.
2.Is OBIEE supports multiple databases?
3.Can we access all the tables of a database using one connection pool.
4.what are the connection types to import metadata in rpd.
5.can we import pk,fk,views into rpd.
6.what are the steps of importing metadata from DWH to rpd.
7.what are the joins in obiee 11g.
8.Is outer join is possible in physical layer?
9.How self join is done in physical layer.
10.what are the joins not supported by obiee 11g.
11.can we import joins from DB to physical layer.
12.How we synchronize rpd and db.
13.How can we remove unused objects from physical layer.
14.How types of analytics are there and which analyticsis used in your project.
15.Give some table and column names from Datawarehouse of your project.
16.What is a connection pool and how many are there is your project.
17.Can we access all the tables in the database using one connection pool?
18.What is your source system and give some table and column names of AP,AR,GL,PO,PA etc.,
19.What are the types of tables present in Datawarehouse.
20.How to check what version of joins or any fucntionality is supported by your Datawarehouse.
21.What is OCI and ODBC?
C.BMM/logical Layer:
1.For what BMM(Business Model and Mapping) layer is required.
2.what are objects of BMM layer.
3.How many Business models or data mart or subject areas can be created in BMM layer.
4.why we have do logical join and what is driving table.
5.what is cardinality.
6.how can we rename all columns at a time in BMM layer.
7.How can we identify a column is measure column or what is the condition for it.
8.Can a Business Model be mapped to multiple DB's in physical layer.
9.Can a logical table be mapped to multiple LTS in physical layer.
10.Can a LTS be mapped to multiple physical tables in physical layer.
11.Can a logical column be mapped to multiple physical columns in physical layer.
12.What is complex join?
13.What is dummy fact table?
14.If we want to use only one table for reports.How it is joined in Logical Layer?
D.Presentation Layer:
1.which layer is visible to the user or developer
2.what are objects of Presentation layer.
3.How many Business Models can a subject area have at time?
4.Can two or more subject areas have same Business Model?
5.on what basis subject areas are created?
6.Can we create nested folders in Presentation Layer.
E.Testing RPD
1.What will be checked when Consistency Check Manager is invoked or ran.
2.what are the difference between Online and offline mode in RPD.
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
F.OFMW EM
1.what are the uses of EM.
2.How many ways are there to start and stop BI servers.
Keep Visiting the blog Updates!
G.Files:Logs,Paths
1.what is the path for storing rpd.
2.what are the files in which rpd details stores.
3.what are the log levels present in obiee 11g.
4.what is the default log level and what is it in production and test.
5.How is the results of a report stored in obiee system.
H.OBIEE 11g Architecture
1.How many tiers are in OBIEE 11g Architecture?
2.What are the main servers in obiee.what is start and stopping sequence of servers.
3.what is node manager and opmnctl.
4.what are configuration and log files present in obiee 11g.
5.which server maintains data security in obiee 11g.
6.we cannot open Analytics application,if which server is down.
7.What is the use of BI java host server in obiee.
I.Adding Multiple Sources
1.what are the conditions to add physical tables to LTS or LT.
2.How to convert a snow flake scheme to star.
3.What is granularity or content logical level.
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
J.Calculations
1.In general calculations can be done at what levels.
2.In OBIEE BMM Layer we can do calculations in how ways and how?
3.When and why we use calculation wizard.
4.We can access expression wizard from?
5.What is INDEXCOL function?
6.How aggregation is referred in logical and physical calculations.
7.What is best practice for calculations and why?
8.What are the aggregate time functions in expression builder?
9.What is CAST Function used for?
10.What are the Display functions and uses?
11.What are the Evaluate/database functions and uses?
12.What are the Time series functions and uses?
K.Creating Dimensional Hierarchies
1.What are the types of Hierarchies?
2.What do u mean by level based Hierarchies?
3.In level based Hierarchies, one column can be mapped with how many levels ?
4.What do u mean by Content Logical level or Granularity.
5.How many level are there in level based Hierarchies.
6.Why we have to use Hierarchies?
7.What is Drill Down,Drill Up,Drill across.
8.What is Chronological Keys?why it is used.
9.What is use of 'Number of Elements at this Level' option.
L.Level Based Measures (LBM)
1.Can we use nested aggregate functions in RPD.
2.What is LBM and what is its use?
New questions will be added regularly so keep Visiting the blog for updates.
III.Learner Level:
A.Analytics
1.What is analytics?
2.To access analytics what servers should be up?
3.What is URL format and port for Analytics.
B.Creating Web Catalog and Reports
1.What is Web Catalog?What is its path?
2.Which server controls Catalog and what is it configuration and log files.
3.What are the folders present in the Catalog and for what purpose.
4.What are the Catalog folders available to users in Analytics.
5.How filters and dashboards are saved in Catalog.
6.What is catalog Manager and uses?
7.Can we get all the reports in excel format.How?
C.Working with Analysis
1.What are the tab present in Analysis.
2.What are the properties of any column in analytics.
3.What are the column properties of a column in analytics.
4.How to hide unnecessary columns in reports.
5.How sorting is done at RPD level.
6.How to avoid duplicates or repeating values in reports.
7.Can we partially format column heading.
8.How can we remove decimals and highlight the negative values?
9.How to highlight data based on conditions?
10.How calculations are done at report level.
11.What are global variables.
12.What is Filter function.
13.What are Bins and uses of it.
14.What is a subject area?
D.Working with Filters
1.How many ways can we develop filters?
2.What is Advanced SQL Filter?
3.What is a prompt?
4.what is presentation variable and its syntax?
5.What is a global filter?
E.Advanced Features of Analysis
1.can we take columns from two subject area and create reports.
2.Can we combine two requests from different subject areas or same?
3.What is Direct database request(DDR)?How to get access?
F.Building Views
1.What is a view and what are default views.
2.How many types of views are there and where they are integrated.
3.What is the difference between Table and Pivot Table view.
4.Why we use graph views?
5.What are gauge and funnel views?
6.What is a filters view.
7.What is Selection Steps.
8.What did the column selector,view selector,Narrative,Ticker,Static text and Legend views do?
9.what are the use of analysis properties.
G.Dashboards
1.What is a Dashboard and how many types are there?
2.What is the use of Smart Rename.
H.Dashboard prompts
1.What are the Dashboard Prompt and how many types are there?
2.How data is returned by a report when a dashboard prompt is used(link).
3.What is a protected filter?
4.What is a server variable?
5.What is a variable prompt?
6.What is a currency prompt?How to configure it and where?
7.What is a presentation variable?
8.What is a request variable?
I.Dashboard objects
1.What are the Dashboard objects?
2.What are the main Dashboard objects?
3.using same dashboard can two users see different reports?how?
4.can we navigate from dashboard to other.How?
5.How can we add comments in dashboards.
6.What is the use of Folder dashboard object?
Click Here!OBIEE Interview Questions And Answers for Experienced
Click Above link new questions are added.
J.Oracle BI Delivers
1.What is the use of Oracle BI Delivers?
2.what is Agent or Job or Schedules or IBOT?
3.Which server maintain Oracle BI Delivers and where it is configured.
4.Where did scheduler details are stored?
5.what is delivery device and delivery profile?what are the locations it is found?
6.How many ways a Agent can be created?
7.How is alerts displayed in dashboards?
8.What is the use of Job Manager?
IV.Specialist level:
A.Aggregate Tables
1.Why we have to go for Aggregate Tables?
2.What is granularity?
B.Partitions and Fragments
1.What is Partitioning and Partitioning types and uses?
2.What is Fragmentation?
3.What is Value based partitioning?
4.What is Fact Based Partitioning?
5.What is Level Based Partitioning?
C.Variables
1.What are Variables and its types?
2.Where we use repository and session variables?
3.Where we use Presentation and request variables?
4.What are the types of repository variables and there syntax.
5.Difference between static and dynamic repository variables?
6.What is a Initialization Block?
7.If the repository variable value is changed in online mode.what happen to result of the result?
8.What are the types of session variables and there syntax.
9.Give some examples of system variables.
10.Difference between system and non system session variables?
11.How data level security or Row Level Security is achieved?
12.What is Data filters?
13.What is Object Permissions?
14.What is Query limit?
15.Can we restrict a user for a particular time period?
16.What is LDAP?How is it managed in OBIEE?
17.What are the default users,groups and roles in obiee 11g.
18.How we Synchronize Application Roles between LDAP and RPD.
19.Is it mandatory to create a connection pool for Initialization block?
2o.What is Row Wise Initialization Blocks and its use?
21.Difference between repository and session variables?
22.What is a presentation variable and its syntax.
23.What is a request variable and its syntax.
D.Modeling Time Series Data
1.Are there any analytical function in obiee?
2.What are Time series functions and uses?
3.What is the analytical function used in period rolling function in obiee 11g?
3.What is Chronological key?
4.Can we created skipped and ragged Hierarchies in time dimension?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
E.Configuring Many to Many Relationships
1.What is Bridge table and its use?
2.What is Helper table and its use?
3.Tell me one feature of OBIEE not available in other BI Tools?
4.What are weight factor and Gap physical columns?
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
F.Setting Implicit Fact Column
1.What is Implicit fact coulmn and its use?
2.What is dimension only query?
3.Can we reports only by taking dimensions or facts?
4.On what bases BI server decides a economical source?
G.Security
1.What are the levels of Security available in obiee 11g?
2.How OBIEE security is divided?
3.What is Authentication and Authorization?
4.How Authentication is preformed in obiee 11g?
5.How External table authentication is done in obiee 11g?
6.If we need to pass external table intilization block,what should be done?
7.Can we run Authorization initialization block after Authentication initialization block?How?
8.Where is new users,groups and roles are created?
9.How to get all users,groups and roles in excel format?
10.How user folders are created in catalog for LDAP amd external table user?
11.What are catalog groups and uses?
12.What are the levels of Authorization a user can be assigned?
13.What authorization user can be assigned at RPD level?
14.What is global header?What does it contain.
15.How we give privileges to create analysis,KPI,dashboards etc., to user?
16.What authorization user can be assigned at Presentation Catalog level?
17.What are types of permissions in OBIEE 11g?
18.What is traverse permission means?
19.What is inheritance precedence among users,groups and roles?
20.What is Globally Unique Identifier (GUID)?
21.What is Impersonation in obiee 11g security?
22.How many users can a LDAP stores?
23.How users know what roles they are assigned?
24.What do you mean by Single Sign on (SSO)?
25.Can you bypass obi server security ?if so how?
H.Cache Management
1.In OBIEE how many types of caches are there?
2.What is the order of report execution?
3.How to bypass and clear OBIPS cache.How?
4.How OBI Server cache is handled in OBIEE 11g?
5.Will obi server cache get deleted on server start or restart?
6.What are advantages and disadvantages of caches?
7.What is Cache Management?
8.What is Purging?How types are there?
9.Can we enable caches on few tables only?If yes,How?
10.What is the use of Event Pooling Table (EPT) and mention table name used for it?
11.What is the accurate method for purging caches?
12.What are ODBC functions or How cache is purged programmatically?
13.Where can we use ODBC functions?
14.How can we issue a SQl statement directly to BI server?
15.What is meant by seeding and types and uses?
16.What is Auto seeding?
I.Usage Tracking
1.How is Usage tracking is done?
2.From which table Usage tracking reports are developed?
3.Where did we configure usage tracking parameter?
4.What is the use of system Mbean Browser?
J.Multi User Development Environment (MUDE)
1.can two or more developer work on RPD at time.How?
2.Is MUDE available in online mode?
3.What is project means in RPD or OBIEE?
4.What is Setup required for MUDE?
5.How to use MUDE Environment?
6.What is merging process?
7.Can we trim a RPD?
8.If two users created same column in same logical table with same formula then what will happens in merging process?
9.Can you compare two different RPDs?
10.Can you merge two Different RPDs.
New questions will be added regularly so keep Visiting the blog for updates.
K.Opaque View / Select Table
1.What is Opaque View and what are its uses?
2.What is deploying view?
L.Alias
1.What is Alias?
2.On one table how alias will be created?
3.To create number of alias depends on what?
4.What are the uses of alias?
5.Difference between Alias and Duplicate Table.
V.OBIEE 11G Advanced New Features
A.Parent Child Hierarchies
1.What is Parent Child Hierarchy or value based Hierarchy.
2.When we go for Parent Child Hierarchies?
3.How levels are present in Parent Child Hierarchies?
4.What is memeber key and parent key?
5.What is relationship distance and Leaf node identifier?
B.Unbalanced Hierarchies (Ragged and Skipped)
1.What is Unbalanced Hierarchy?
2.What is skipped Hierarchy and Ragged Hierarchy?
C.Actions Links
1.What are Actions Links and uses?
2.What is the use of Interaction Tab?
3.What are Actions?
D.Master Detail Report
1.What is a Master Detail Report?
2.can we develop a report Using Hierarchy Object?
3.What is a condition?How it is used?
E.Upgrade or Migration
1.How do you Upgrade or Migrate from OBI 10g to OBI 11g?
F.Deployment or Migration
1.What do you means by Deployment?
2.What are the Deployment components in obiee 11g?
3.Can we do partially deployment of catalog and rpd?
4.Recommended mode for catalog deployment?
5.What is purpose of archive option?
6.Can we get all reports in catalog in excel format?How?
7.How to get a document of the repository?
G.KPI (Key Performance Indicator)
1.What are KPI's and uses of it?
2.Can KPI dimensionalized?
3.What is KPI Watch List?
4.What is Score Card?
I.ID Column
1.What is the use of ID Column?
J.ORACLE BI FOR MS OFFICE
1.How to download BI office Plug-in?
Answers will updated soon........Visit again!
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
Click Above link new questions are added.
New questions will be added regularly so keep Visiting the blog for updates.
OBIEE Interview Questions And Answers
I.Introduction:
1.What is the end to end life cycle of OBIEE?
2.what are the type of obiee 11g installations and port configurations.
3.what are the obiee 11g components and types.
4.what are the types of tables and columns in obiee.
5.what is schema and types scheme in obiee.
6.what is obiee history and latest versions.
7.Differece between obiee 10g and 11g.
8.what is meant by conformed dimensions.
9.Difference between snow flake and star schemas.
10.What is surrogate key?
11.What is mixed schema?
12.Which OBIEE Versions did you worked on in your projects?
Keep Visiting the blog Updates!
II.Practionser Level:BI Admin Tool(RPD)
A.Introduction:
1.what is use of BI admin tool.
2.what do u mean by metadata and rpd.
3.what are the three layers in rpd.
4.What did a rpd stores and what is it size general and in your Project.
5.What are modes of using RPD?
B.Physcial Layer:
1.what are objects of physical layer.
2.Is OBIEE supports multiple databases?
3.Can we access all the tables of a database using one connection pool.
4.what are the connection types to import metadata in rpd.
5.can we import pk,fk,views into rpd.
6.what are the steps of importing metadata from DWH to rpd.
7.what are the joins in obiee 11g.
8.Is outer join is possible in physical layer?
9.How self join is done in physical layer.
10.what are the joins not supported by obiee 11g.
11.can we import joins from DB to physical layer.
12.How we synchronize rpd and db.
13.How can we remove unused objects from physical layer.
14.How types of analytics are there and which analyticsis used in your project.
15.Give some table and column names from Datawarehouse of your project.
16.What is a connection pool and how many are there is your project.
17.Can we access all the tables in the database using one connection pool?
18.What is your source system and give some table and column names of AP,AR,GL,PO,PA etc.,
19.What are the types of tables present in Datawarehouse.
20.How to check what version of joins or any fucntionality is supported by your Datawarehouse.
21.What is OCI and ODBC?
C.BMM/logical Layer:
1.For what BMM(Business Model and Mapping) layer is required.
2.what are objects of BMM layer.
3.How many Business models or data mart or subject areas can be created in BMM layer.
4.why we have do logical join and what is driving table.
5.what is cardinality.
6.how can we rename all columns at a time in BMM layer.
7.How can we identify a column is measure column or what is the condition for it.
8.Can a Business Model be mapped to multiple DB's in physical layer.
9.Can a logical table be mapped to multiple LTS in physical layer.
10.Can a LTS be mapped to multiple physical tables in physical layer.
11.Can a logical column be mapped to multiple physical columns in physical layer.
12.What is complex join?
13.What is dummy fact table?
14.If we want to use only one table for reports.How it is joined in Logical Layer?
D.Presentation Layer:
1.which layer is visible to the user or developer
2.what are objects of Presentation layer.
3.How many Business Models can a subject area have at time?
4.Can two or more subject areas have same Business Model?
5.on what basis subject areas are created?
6.Can we create nested folders in Presentation Layer.
E.Testing RPD
1.What will be checked when Consistency Check Manager is invoked or ran.
2.what are the difference between Online and offline mode in RPD.
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
F.OFMW EM
1.what are the uses of EM.
2.How many ways are there to start and stop BI servers.
Keep Visiting the blog Updates!
G.Files:Logs,Paths
1.what is the path for storing rpd.
2.what are the files in which rpd details stores.
3.what are the log levels present in obiee 11g.
4.what is the default log level and what is it in production and test.
5.How is the results of a report stored in obiee system.
H.OBIEE 11g Architecture
1.How many tiers are in OBIEE 11g Architecture?
2.What are the main servers in obiee.what is start and stopping sequence of servers.
3.what is node manager and opmnctl.
4.what are configuration and log files present in obiee 11g.
5.which server maintains data security in obiee 11g.
6.we cannot open Analytics application,if which server is down.
7.What is the use of BI java host server in obiee.
I.Adding Multiple Sources
1.what are the conditions to add physical tables to LTS or LT.
2.How to convert a snow flake scheme to star.
3.What is granularity or content logical level.
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
J.Calculations
1.In general calculations can be done at what levels.
2.In OBIEE BMM Layer we can do calculations in how ways and how?
3.When and why we use calculation wizard.
4.We can access expression wizard from?
5.What is INDEXCOL function?
6.How aggregation is referred in logical and physical calculations.
7.What is best practice for calculations and why?
8.What are the aggregate time functions in expression builder?
9.What is CAST Function used for?
10.What are the Display functions and uses?
11.What are the Evaluate/database functions and uses?
12.What are the Time series functions and uses?
K.Creating Dimensional Hierarchies
1.What are the types of Hierarchies?
2.What do u mean by level based Hierarchies?
3.In level based Hierarchies, one column can be mapped with how many levels ?
4.What do u mean by Content Logical level or Granularity.
5.How many level are there in level based Hierarchies.
6.Why we have to use Hierarchies?
7.What is Drill Down,Drill Up,Drill across.
8.What is Chronological Keys?why it is used.
9.What is use of 'Number of Elements at this Level' option.
L.Level Based Measures (LBM)
1.Can we use nested aggregate functions in RPD.
2.What is LBM and what is its use?
New questions will be added regularly so keep Visiting the blog for updates.
III.Learner Level:
A.Analytics
1.What is analytics?
2.To access analytics what servers should be up?
3.What is URL format and port for Analytics.
B.Creating Web Catalog and Reports
1.What is Web Catalog?What is its path?
2.Which server controls Catalog and what is it configuration and log files.
3.What are the folders present in the Catalog and for what purpose.
4.What are the Catalog folders available to users in Analytics.
5.How filters and dashboards are saved in Catalog.
6.What is catalog Manager and uses?
7.Can we get all the reports in excel format.How?
C.Working with Analysis
1.What are the tab present in Analysis.
2.What are the properties of any column in analytics.
3.What are the column properties of a column in analytics.
4.How to hide unnecessary columns in reports.
5.How sorting is done at RPD level.
6.How to avoid duplicates or repeating values in reports.
7.Can we partially format column heading.
8.How can we remove decimals and highlight the negative values?
9.How to highlight data based on conditions?
10.How calculations are done at report level.
11.What are global variables.
12.What is Filter function.
13.What are Bins and uses of it.
14.What is a subject area?
D.Working with Filters
1.How many ways can we develop filters?
2.What is Advanced SQL Filter?
3.What is a prompt?
4.what is presentation variable and its syntax?
5.What is a global filter?
E.Advanced Features of Analysis
1.can we take columns from two subject area and create reports.
2.Can we combine two requests from different subject areas or same?
3.What is Direct database request(DDR)?How to get access?
F.Building Views
1.What is a view and what are default views.
2.How many types of views are there and where they are integrated.
3.What is the difference between Table and Pivot Table view.
4.Why we use graph views?
5.What are gauge and funnel views?
6.What is a filters view.
7.What is Selection Steps.
8.What did the column selector,view selector,Narrative,Ticker,Static text and Legend views do?
9.what are the use of analysis properties.
G.Dashboards
1.What is a Dashboard and how many types are there?
2.What is the use of Smart Rename.
H.Dashboard prompts
1.What are the Dashboard Prompt and how many types are there?
2.How data is returned by a report when a dashboard prompt is used(link).
3.What is a protected filter?
4.What is a server variable?
5.What is a variable prompt?
6.What is a currency prompt?How to configure it and where?
7.What is a presentation variable?
8.What is a request variable?
I.Dashboard objects
1.What are the Dashboard objects?
2.What are the main Dashboard objects?
3.using same dashboard can two users see different reports?how?
4.can we navigate from dashboard to other.How?
5.How can we add comments in dashboards.
6.What is the use of Folder dashboard object?
Click Here!OBIEE Interview Questions And Answers for Experienced
Click Above link new questions are added.
J.Oracle BI Delivers
1.What is the use of Oracle BI Delivers?
2.what is Agent or Job or Schedules or IBOT?
3.Which server maintain Oracle BI Delivers and where it is configured.
4.Where did scheduler details are stored?
5.what is delivery device and delivery profile?what are the locations it is found?
6.How many ways a Agent can be created?
7.How is alerts displayed in dashboards?
8.What is the use of Job Manager?
IV.Specialist level:
A.Aggregate Tables
1.Why we have to go for Aggregate Tables?
2.What is granularity?
B.Partitions and Fragments
1.What is Partitioning and Partitioning types and uses?
2.What is Fragmentation?
3.What is Value based partitioning?
4.What is Fact Based Partitioning?
5.What is Level Based Partitioning?
C.Variables
1.What are Variables and its types?
2.Where we use repository and session variables?
3.Where we use Presentation and request variables?
4.What are the types of repository variables and there syntax.
5.Difference between static and dynamic repository variables?
6.What is a Initialization Block?
7.If the repository variable value is changed in online mode.what happen to result of the result?
8.What are the types of session variables and there syntax.
9.Give some examples of system variables.
10.Difference between system and non system session variables?
11.How data level security or Row Level Security is achieved?
12.What is Data filters?
13.What is Object Permissions?
14.What is Query limit?
15.Can we restrict a user for a particular time period?
16.What is LDAP?How is it managed in OBIEE?
17.What are the default users,groups and roles in obiee 11g.
18.How we Synchronize Application Roles between LDAP and RPD.
19.Is it mandatory to create a connection pool for Initialization block?
2o.What is Row Wise Initialization Blocks and its use?
21.Difference between repository and session variables?
22.What is a presentation variable and its syntax.
23.What is a request variable and its syntax.
D.Modeling Time Series Data
1.Are there any analytical function in obiee?
2.What are Time series functions and uses?
3.What is the analytical function used in period rolling function in obiee 11g?
3.What is Chronological key?
4.Can we created skipped and ragged Hierarchies in time dimension?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
E.Configuring Many to Many Relationships
1.What is Bridge table and its use?
2.What is Helper table and its use?
3.Tell me one feature of OBIEE not available in other BI Tools?
4.What are weight factor and Gap physical columns?
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
Click Above link new questions are added.
F.Setting Implicit Fact Column
1.What is Implicit fact coulmn and its use?
2.What is dimension only query?
3.Can we reports only by taking dimensions or facts?
4.On what bases BI server decides a economical source?
G.Security
1.What are the levels of Security available in obiee 11g?
2.How OBIEE security is divided?
3.What is Authentication and Authorization?
4.How Authentication is preformed in obiee 11g?
5.How External table authentication is done in obiee 11g?
6.If we need to pass external table intilization block,what should be done?
7.Can we run Authorization initialization block after Authentication initialization block?How?
8.Where is new users,groups and roles are created?
9.How to get all users,groups and roles in excel format?
10.How user folders are created in catalog for LDAP amd external table user?
11.What are catalog groups and uses?
12.What are the levels of Authorization a user can be assigned?
13.What authorization user can be assigned at RPD level?
14.What is global header?What does it contain.
15.How we give privileges to create analysis,KPI,dashboards etc., to user?
16.What authorization user can be assigned at Presentation Catalog level?
17.What are types of permissions in OBIEE 11g?
18.What is traverse permission means?
19.What is inheritance precedence among users,groups and roles?
20.What is Globally Unique Identifier (GUID)?
21.What is Impersonation in obiee 11g security?
22.How many users can a LDAP stores?
23.How users know what roles they are assigned?
24.What do you mean by Single Sign on (SSO)?
25.Can you bypass obi server security ?if so how?
H.Cache Management
1.In OBIEE how many types of caches are there?
2.What is the order of report execution?
3.How to bypass and clear OBIPS cache.How?
4.How OBI Server cache is handled in OBIEE 11g?
5.Will obi server cache get deleted on server start or restart?
6.What are advantages and disadvantages of caches?
7.What is Cache Management?
8.What is Purging?How types are there?
9.Can we enable caches on few tables only?If yes,How?
10.What is the use of Event Pooling Table (EPT) and mention table name used for it?
11.What is the accurate method for purging caches?
12.What are ODBC functions or How cache is purged programmatically?
13.Where can we use ODBC functions?
14.How can we issue a SQl statement directly to BI server?
15.What is meant by seeding and types and uses?
16.What is Auto seeding?
I.Usage Tracking
1.How is Usage tracking is done?
2.From which table Usage tracking reports are developed?
3.Where did we configure usage tracking parameter?
4.What is the use of system Mbean Browser?
J.Multi User Development Environment (MUDE)
1.can two or more developer work on RPD at time.How?
2.Is MUDE available in online mode?
3.What is project means in RPD or OBIEE?
4.What is Setup required for MUDE?
5.How to use MUDE Environment?
6.What is merging process?
7.Can we trim a RPD?
8.If two users created same column in same logical table with same formula then what will happens in merging process?
9.Can you compare two different RPDs?
10.Can you merge two Different RPDs.
New questions will be added regularly so keep Visiting the blog for updates.
K.Opaque View / Select Table
1.What is Opaque View and what are its uses?
2.What is deploying view?
L.Alias
1.What is Alias?
2.On one table how alias will be created?
3.To create number of alias depends on what?
4.What are the uses of alias?
5.Difference between Alias and Duplicate Table.
V.OBIEE 11G Advanced New Features
A.Parent Child Hierarchies
1.What is Parent Child Hierarchy or value based Hierarchy.
2.When we go for Parent Child Hierarchies?
3.How levels are present in Parent Child Hierarchies?
4.What is memeber key and parent key?
5.What is relationship distance and Leaf node identifier?
B.Unbalanced Hierarchies (Ragged and Skipped)
1.What is Unbalanced Hierarchy?
2.What is skipped Hierarchy and Ragged Hierarchy?
C.Actions Links
1.What are Actions Links and uses?
2.What is the use of Interaction Tab?
3.What are Actions?
D.Master Detail Report
1.What is a Master Detail Report?
2.can we develop a report Using Hierarchy Object?
3.What is a condition?How it is used?
E.Upgrade or Migration
1.How do you Upgrade or Migrate from OBI 10g to OBI 11g?
F.Deployment or Migration
1.What do you means by Deployment?
2.What are the Deployment components in obiee 11g?
3.Can we do partially deployment of catalog and rpd?
4.Recommended mode for catalog deployment?
5.What is purpose of archive option?
6.Can we get all reports in catalog in excel format?How?
7.How to get a document of the repository?
G.KPI (Key Performance Indicator)
1.What are KPI's and uses of it?
2.Can KPI dimensionalized?
3.What is KPI Watch List?
4.What is Score Card?
I.ID Column
1.What is the use of ID Column?
J.ORACLE BI FOR MS OFFICE
1.How to download BI office Plug-in?
Answers will updated soon........Visit again!
Click Here!OBIEE Interview Questions And Answers for 4 years Experienced
These questions are asked
in the interviews of
ORACLE INDIA Hyderabad
GEN PACT Hyderabad
GEN PACTGURGAON (NEW
DELHI)
ACCION LABS (MALAYSIA)
AFUAIT (BANGALORE AND
QATAR)
TCS AHAMADABAD (GUJARAT)
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....