Q: How you generally Approach to your Analytics Project?
A: Any project should start from defining the scope of the project and the approach
should be not to deviate from the scope. Then the project should be functionally divided into smaller modules generally done by project managers along with technical and functional leads.
The functional leads then decide on majorly three things:
1. According to the defined scope of the project they start gathering requirements while
interacting with the clients.
2. They had a discussion with the technical leads and try to reach a solution.
3. Technical leads will decide what schemas to create and what requirements are going to
fulfill by that schema. Technical leads discuss all this with the developers and try to close requirements. Simultaneously testing and deployment is planned in a phased manner.
Q: What are the Challenges you faced while making of Reports?
A: Making of a 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.
Q: What you will do when your Report is not Fetching Right Data?
A: 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 be 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 could be a problem with the joins and
relations in the schema. You need to discover that analyzing and digging deep into the
matter.
Q: How analytics Process Your Request When you create your Requests?
A: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 optimized 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.
Q: From where u Get the Logical Query of your Request?
A: The logical SQL generated by the server can be viewed in BI Answers. If I have not understood the question, Please raise your voice.
Q: What is Global Filter and how are they different from Column Filter?
A: 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 don’t understand where and how it can be user. I heard of global variables but not global filters.
Q: How to hide Certain Columns from a User?
A: Application access level security- Do not add the column in the report, do not add the column in the presentation layer.
A: Any project should start from defining the scope of the project and the approach
should be not to deviate from the scope. Then the project should be functionally divided into smaller modules generally done by project managers along with technical and functional leads.
The functional leads then decide on majorly three things:
1. According to the defined scope of the project they start gathering requirements while
interacting with the clients.
2. They had a discussion with the technical leads and try to reach a solution.
3. Technical leads will decide what schemas to create and what requirements are going to
fulfill by that schema. Technical leads discuss all this with the developers and try to close requirements. Simultaneously testing and deployment is planned in a phased manner.
Q: What are the Challenges you faced while making of Reports?
A: Making of a 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.
Q: What you will do when your Report is not Fetching Right Data?
A: 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 be 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 could be a problem with the joins and
relations in the schema. You need to discover that analyzing and digging deep into the
matter.
Q: How analytics Process Your Request When you create your Requests?
A: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 optimized 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.
Q: From where u Get the Logical Query of your Request?
A: The logical SQL generated by the server can be viewed in BI Answers. If I have not understood the question, Please raise your voice.
Q: What is Global Filter and how are they different from Column Filter?
A: 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 don’t understand where and how it can be user. I heard of global variables but not global filters.
Q: How to hide Certain Columns from a User?
A: Application access level security- Do not add the column in the report, do not add the column in the presentation layer.
Q: How can we Enable Drills in a Given
Column Data?
A: To enable Drill down for a column, it should be included in the hierarchy in OBIEE. Hyperion IR has a drill anywhere feature where don’t have to define and can drill to any available column.
Q: Is Drill down Possible without the attribute being a Part of a Hierarchical Dimension?
A: No
A: To enable Drill down for a column, it should be included in the hierarchy in OBIEE. Hyperion IR has a drill anywhere feature where don’t have to define and can drill to any available column.
Q: Is Drill down Possible without the attribute being a Part of a Hierarchical Dimension?
A: No
Q: How do u Conditional Format.?
A: while creating a chat in BI Answers, you can define the conditions and can apply color formatting.
Q: Online/Offline Mode how it Impact in Dev and Deployment?
A: 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.
A: while creating a chat in BI Answers, you can define the conditions and can apply color formatting.
Q: Online/Offline Mode how it Impact in Dev and Deployment?
A: 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.
Q: What
is BI LIFE CYCLE?
A:1.
Gather Business Requirements
2. Identify source systems
3. Design ETL to load to a DW if source data doesn’t exist.
4. Build a repository
5. Build dashboard or use answers for reporting.
6. Define security (LDAP or External table…)
7. Based on performance, decide on aggregations and/or caching mechanism.
8. Testing and QA.
2. Identify source systems
3. Design ETL to load to a DW if source data doesn’t exist.
4. Build a repository
5. Build dashboard or use answers for reporting.
6. Define security (LDAP or External table…)
7. Based on performance, decide on aggregations and/or caching mechanism.
8. Testing and QA.
Q:
Define REPOSITORY
A:o
Repository stores the Meta data information. BI repository is a file system,
extension of the repository file. rpd.
o META DATA REPOSITORY
o In BI Server, all the rules needed for security, data modeling, aggregate navigation, caching, and
connectivity is stored in metadata repositories.
o Each metadata repository can store multiple business models. BI Server can access multiple repositories
o META DATA REPOSITORY
o In BI Server, all the rules needed for security, data modeling, aggregate navigation, caching, and
connectivity is stored in metadata repositories.
o Each metadata repository can store multiple business models. BI Server can access multiple repositories
Q:
How do you define the relationship between facts and dimensions in BMM layer?
A: Using
complex join, we can define relationship between facts and dimensions in BMM
layer.
Q: what are the things you can do in the BMM layer?
A:
Aggrigation navigation,level base matrics,time series wizard,create new logical
column,comlex join.
What
will happen if we removed all columns from detail level of the Dimension
Hierarchy?
A: In that
scenario the upper level will act as detail level and it will give warning
also. That level has no key to act as uniquely identify members.
Then we will not be able to see the
detail level data.
What all
measure you have created in your project.
A: Level based measures, Share Measure,
Dollars.......
Q. If
there is column in database having data type as long then how will you import
in RPD.
A: We will
be able to import it in RPD but we will not be able to see the data.
Suppose
there is managers group and we want to give the access to data for managers
only not for others then how you will achieve this.
A:We will give the data level security
to managers.
Q. If we
want to hide Answers link for particular user then how you will do that.
A:In
Presentation services go to settings –>Manage Privileges -->Access
to Answers -->we will not add the particular user to
access this privilege.
Q. What
is dimension hierarchy?
A:
A
hierarchy is a set of parent-child relationships between attributes within a
dimension. These hierarchy attributes, called levels, roll up from child to
parent, for example, daily sales could roll up to weekly sales, which further
rollup to month to quarter to yearly sales. When one attribute rolls up to
another, it implies a one-to-many relationship.
Q. How
will you achieve data level security in RPD and Web cats (UI)?
A:
Data
level security can be achieved using session variable in UI or IN RPD using
filters from Permission tab.
Q: Why
we create complex join?
A: Complex
Join in used in the Business Model & Mapping Layer (BMM layer) in the
repository. Logical tables in a BMM layer can have multiple logical tables
sources (LTS). Complex join actually is an intelligent join between LTSs of two
logical tables in BMM Layer. When two columns are selected for a query in
Answers/Dashboard, BI Server reads the complex join between two logical tables
and then intelligently & dynamically selects the LTSs to join.
When
Complex joins are used in the business layer then they are really acting as
placeholders.
They
allow the OBI Server to decide on which are the best joins define in the
Physical Layer to satisfy the request.
In a
Dimension, you may have multiple Logical Table sources that all join to one
fact table.
The OBI
Server will then decide the best joins to use to meet the requirements.
The
reasoning behind using a foreign key join in the BMM layer is only when you
need to specify precisely which physical join should be used and you don't want
the BI Server to decide.
Q: Uses
of level based measures.
A: A
level-based measure is a
column whose values are always calculated to a specific level of aggregation,
is a measure pinned at a certain level of the dimension. For Example, if you
have a measure called “Dollars”,you can create a “Level Based Measure” called
“Yearly Dollars” which is Dollars for a
Year. This measure will always return the value for the year even if you drill
down to a lower level like quarter, month… etc. To create a level based
measure, create a new logical column based on the original measure. Drag and
drop the new logical column to the appropriate level in the Dimension hierarchy
(in the above example you will drag and drop it to Year in Time Dim
e.g Monthly Total
Sales or Quarterly Sales are the examples.
You can compare
monthly sales with quarterly sales. You can compare customer orders this
quarter to orders this year
Q: Difference between BI and Siebel analytics?
A:In siebel
drilling and pivot table is not allowed.
Q. Which
Tool Do you think is more comfortable out of these two?
A: BI
Q. How
will you provide a tool tip in OBIEE?
A:
First
off, in the Administration tool, open up the properties of a column
Check the "Custom display name" and just leave the default value. Then enter in some text into the Description box...
Check the "Custom display name" and just leave the default value. Then enter in some text into the Description box...
You
can see that the text I put into the Description box matches that in the tool
tip from Answers.
Q. If a
user want that on clicking on the chart a drilldown is possible then what is
the option you have to select?
A:
In
additional charting options one tab is available as INTERACTION we can choose
drill option from there.
Q.
Suppose there are three columns in a request and a user want that the first two
columns remain static and the last column user can change at run time how you
will achieve the task?
A:
Using
column selector
Q. Is
the option of Radio button is available in OBIEE? If yes then how & if no
then what is the solution for that?
A:
The
option is not readily available in obiee we can do it using text object by
writing script
Q.
Suppose there is a dimension hierarchy in the repository for Periods. If the
user want to restrict on the UI how is it possible?
A:
column
format->no interaction
Q. What do you understand by Guided Navigation link?
A:--It gives us idea to show a
particular request according to result of any another request.
---There are three types
as static, dynamic and conditional
Q. What
happens whenever we add a new Section to a pivot table?
A:
It
gives detailed information according to column you add in section in a detailed
manner.
Q: How
will you set restriction on your data?
A:
To
add restriction on your data we can go
to-->manage-->security-->permissions-->and then set query limits or
we can add dynamic filtering.
Q:
How will you imply a formula on a column in presentation Services?
A:
Column
formula tab
Q. Diff
ways to improve the performance of your reports?
A: Alias Tables
Using Aggregate Navigation
Using Cache
Connection Pool
Turning Off Log
Level
Using Database
Hints
Using Where Clause
Q. How
will you restrict the value of one prompt based on another prompt?
A:
In
Dashboard prompt Using constraint option
Q: One
subject area is working fine but other is giving error why?
A:
User
will not have permission to access that subject area
Repository is inconsistent
Q: How
to create iBots in Delivers?
A:In
Answers on the top there is an option-->more products-->Create ibot
Q: How
will you achieve object level security?
A:
Setting
permission in manage security
Q: In
which View you can change the column name dynamically?
A: Column selector
Q: How
will you connect two fact tables?
A: In dimensional
modelling there is no fact to fact joining
Q. What
are Confirmed Dimension?
A: one dimension is joined to more than
one fact.
Q. What
are connection pool properties?
A:
Name,call
interface,Max connections-.datasource name,enale connection pooling,shared
logon
Q. Which
call interface do you use in your repository?
A:oci
10g,odbc 3.5
Q. What
are the diff variable in obiee?
A:
Repository-static,
dyanmic
server-system
,non system
presentation
Q: What
do you mean by Star Schema?
A:One fact
associated with multiple dimensions
Q:
Difference between Star and Snowflake Schema?
A:
Snowflake
schema:In This Demsion Table Associated
With Sub Dimenson Table.
Q: Which
dimension hierarchy you have created in your Report?
A:
Period,customer,product
Q: What
is alias Table and in which Scenario you have used?
A:
An
Alias table (Alias) is a physical table with the type of Alias.
It
is a reference to a Physical table, and inherits all its column definitions and
some properties from the Physical
table. Alias Tables can be an important part of designing a physical layer
OBIEE
doesn’t support the self-join, so we can use alias table
to
implement self-join in OBIEE.
The
following is a list of the main reasons to create an alias table:
* To reuse an existing table more than once in
your physical layer (without having to import it several times)
* To set up multiple alias tables, each with
different keys, names, or joins
* To help you design sophisticated star or
snowflake structures in the business model layer.ex
It
helps when we have confirm dimension (e.f time dimension) and we want to join
dimension different way
Q. When do you use
“Use logical column as a source” and when to use “Use Physical column as a
source”?
A: When we
need the aggregation rule to be applied after the calculation the use physical
column as source and if we want before the calculation the logical column
as a source
Q. What
is LTS?
A: In this we have the mapping of the
logical column to physical column.in this we can set the content tab and
fragmentation there.
Q. Do we
have multiple star schema in one business model?
A:
Yes
we can have
Q. What is
implicit fact?
A: If we
have to made the report in which we need two dimensions only and no fact ,in
that scenario we set one fact column as implicit fact
Q.What are
aggregate tables?
A:That
stores precomputed aggregated data for the specified level.it helps in
improving the performance.
Q.What is
a dimension hierarchy and how will it help you in BI?
A:A
hierarchy is a set of parent-child relationships between attributes within a
dimension. These hierarchy attributes, called levels, roll up from child to
parent, for example, daily sales could roll up to weekly sales, which further
rollup to month to quarter to yearly sales. When one attribute rolls up to
another, it implies a one-to-many relationship.
Q.What are
services which are required while OBIEE is being executed?
A:Oracle
BI Java Host if we want any java components are there
Oracle
BI Presentation Services
Oracle
BI Server
Q.How will
you assign permissions to users?
A:-Go
Manage--->Security--->-Click on users--->Dialog box gets
open--->-click on permissions and add permissions you want
Q.How will
you connect your data source to your repository?
A: Through
connection pool.
Q.From
where can we set our log levels for the Users?
A:Go
Manage--->Security--->-Click on users--->Dialog box gets
open--->-click on scroll down log level you want to set for a particular
user.
Q.We have
run a query and now we need to modify the same but it has not appeared in our
logs why?
A:-log
level set to zero.
Q.What are
permissions and privileges in OBIEE?
A:
Permissions allow repository users to perform tasks within a folder. With
folder permissions, you can control user access to the folder and the tasks you
permit them to perform. Folder permissions work closely with repository
privileges. Privileges grant access to specific tasks, while permissions grant
access to specific folders with read, write, and execute access. However, any
user with the Super User privilege can perform all tasks across all folders in
the repository. Folders have the following types of permissions:
· Read permission.
You can view the folder and objects in the folder.
· Write permission. You can create or edit
objects in the folder.
· Execute permission. You can run or schedule
workflows in the folder.
Q.I have
development repository server running on one maching having dev repository.
A: In production we have another repository server with prod repository.
I want to move repository objects from dev to prodution.
A: In production we have another repository server with prod repository.
I want to move repository objects from dev to prodution.
Q. How to move dashboard to another location created locally on your
machine?
A:In catalog manager option we will archive the catalog folder and
paste it on our machine
Q.There
are 5 dashboards and few pages on each
dashboard, data is retrieved for first 4 dashboards very quickly, but lot of
time is taken for last dashboard,so how u will analyze the problem?
A:we have to check he report and its log
Q.Difference
between column selector and view selector
A:Use the Column
Selector view to enable users to dynamically change the columns that appear
in results. This permits the analysis of data along several dimensions. By
changing the facts,users can dynamically alter the content of the results.
Using View selector you user can see View as their requirement,that which view
they want to see.
Q.How to
add page in dashboard?
A:In
dashboard list there is a sign + sign Click on it 0ne page will
get added automatically to
the dashboard.
Q.Use of
Narrative view, Real time Use.
A:Show
Results as one or more paragraphs of text.
--In
narrator view user can add html script so that it can be more user friendly.
Q.What was the
development environment in which you used to work?
A:single
user
Q.Which variables u
have created in your project?
A:Session
Q.Can we merge two
repositories?
A:yes
Q.What is project
flow of ur latest project?
A:1.
Gather Business Requirements
2.
Identify source systems
3.
Design ETL to load to a DW if source data doesn’t exist.
4.
Build a repository
5.
Build dashboard or use answers for reporting.
6.
Define security (LDAP or External table…)
7.
Based on performance, decide on aggregations and/or caching mechanism.
8.
Testing and QA.
requirement--datamodel--repository
creation--reports--again all the steps
Q.In ur
project data came from which system?
A:olap
Q.describe
the architecture of BI ?
A:client<-->presentation
server<--Bi server--Data sources
Q.Diff people from
diff cities should be able to see same report and they should see data only of
their respective region.?
A:using
session variables or using filter tab.
Q.How to
create user group and users?
A:In
repository we have Menu as Mange in toolbar
--Manage-->Security
--There
Click on users in left pane
--Then
in right pane right click create new user you will get created.
--There
Click on group in left pane
--Then
in right pane right click create new group you will get created.
Q.What is
the use of Time series function?
A:Time
Series Function are used for comparisons
1)Ago
Function--->Calculates aggregated value as of some time period shifted from current time.
ago(<measure>,<time
level>,<number to shift>)
2)Todate--->Aggregates
a measure attribute from the beginning of a specified time period ti the currently
displayed time.
ToDate(<measure>,<time
level>)
Q.Describe ur roles
and responsibilites in project?
A:Specific
to your project
Q.If the column
contains null values and you want to put certain value Instead of showing null,
how you will do this?
A:we have
to write the case statement case when
country='null' then 'India' end.
Q.How the
performance is increased by cache management?
A:In cache
management instead of firing a query to direct database it get fired
to cache and retrives result from their.thus
query response time decreases.
And performance increases.
Q.How Cache improves
the performance?
A:1)
Achieving better performance for query by not going to Database server and
satisfying request from cache file on OBIEE server itself.( There are some
criteria for cache hit to occur)
2) It saves network resources by not make round trip.
2) It saves network resources by not make round trip.
Q.Why
there are different logging levels provided?
A:what
type of information particular user required depending upon that the log levels
are provided Set the logging level based on the amount of logging you want to
do. In normal operations, logging is generally disabled (the logging level is
set to 0). If you decide to enable logging, choose a logging o level of 1 or 2.
These two levels are designed for use.
Level
0
·
No logging.
Level
1
·
Logs the SQL statement issued from the
client application.
·
Logs elapsed times for query compilation,
query execution, query cache processing, and back-end database processing.
·
Logs the query status (success, failure,
termination, or timeout). Logs the user ID, session ID, and request ID for each
query.
Level
2
·
Logs everything logged in Level 1.
·
Additionally, for each query, logs the
repository name, business model name, presentation catalog (called Subject Area
in Answers) name, SQL for the queries issued against physical databases,
queries issued against the cache, number of rows returned from each query
against a physical database and from queries issued against the cache, and the
number of rows returned to the client application.
Q.Name some of the
reports you have created.
A:specific
to your project
Q.Can we create
complex join in physical layer if yes how and when?
A:yes we
can,If you have to join two tables in physical layer and the data type of the
columns on which you have to join is not same then what we would complex join
e.g cast(A.column_name as NUMBER) =
B.column_name
Q.How we
create drilldown in UI?
A:In the
column formula in the interaction tab select
drill option.
Q.When to
use Pivot table View and when to use simple table view.
A:-When
user want to view data as per rows and columns
in different perspectives we use pivot table otherwise simple table
view.
Q.What is
briefing book?
A:--If a
user wants to view a specific UI request even when he is not connected to
a BI server then he can save a request
in a briefing book ,download it and then view it using briefing book reader.
Q.What is
Dashboard prompts.
A:Filter
object filters all content on dashboard page and can be used to populate
variables.
Q.What is
MUD and how did you set up that in your project?
A:-- Create a shared directory on the network
for Multi-user Development (MUD).
-- Open the rpd to use in MUD. From Tools->Options, setup the
MUD directory to point to the above directory.
-- Define projects within the rpd to allow multiple users to
develop within their subject area or Facts.
-- Save and move the rpd to the shared directory setup in point 1.
-- When users work in the MUD mode, they open the admin tool and
start with
-- MUD ->Checkout to checkout the project they need to work on
(not use the File open as you would usually do).
-- After completely the development, user checkin the changes back
to the network and merge the changes.
Q.In Which
mode you have done the development, online or offline?
A:Offline
--One
can also do it in online mode if there is any work going on that rpd.
Q.If you
want to import 5 tables from SQL server database and 5 Tables from oracle
database can we do this?
A:Yes.
Q.Where
Presentation variables are declared and use
A:Presentation
variables can only be set using dashboard prompts.
Q.What are Level
based measures.
A:A
level-based measure is a column whose values are always calculated to a
specific level of aggregation. For example, a company might want to measure its
revenue based on the country, based on the region, and based on the city. You
can set up columns to measure CountryRevenue, RegionRevenue, and CityRevenue.
Q.What are Fact &
dimension tables and relationship between them.
A:A fact
table is a table with measures. They must be defined in a logical fact
table.Each measure has its own aggregation rule such as SUM, AVG, MIN or
MAX.Aggregation rules define the way by which business would like to compare
values of a measure.
--Dimension
tables contain attributes that describe business entities.
--
For example, the Customers dimension can contain attributes like Region,
Subregion, Country, State, Customer.
Q.What
are Left outer join, inner join. When do you use inner join and when Outer
Join.
A:Outer Join
Definition:
An
outer join selects all of the records from one database table and only
those records in the second table that have matching values in the joined
field. In a left outer join, the selected records will include all of
the records in the first database table. In a right outer join, the
selected records will include all records of the second database table. One or
more fields can serve as the join fields.
Inner
Join
Definition:
An
inner join is a join that selects only those records from both database
tables that have matching values. Records with values in the joined field that
do not appear in both of the database tables will be excluded from the query.
One or more fields can serve as the join fields.
·
The inner join is also known as an equi-join.
Q.Modes of RPD when
& how can you access.
A:--online:
when the rpd is on server the we have to open it in online mode for editing.
Caching can be done only
in online mode
--offline:when the repository is not on
server
Q. Tell me
about the scope of dashboard prompts.
A:There
are two scpoes of dashboard Page And Dashboard.
Page
prompt:The scope of the prompt is for that page only.
Report Prompt:The scope of the report prompt is for that report only.
Suppose, you have a Prompt on Year and you want to filter only the reports (that are prompted on Year) on that page on the selected value, go for page prompt. Reports on the other pages will not be affeted by this selection.
On the other hand, if you make this as a dashboard prompt, all the reports (that are prompted on Year) on all the pages (in the same dashboard) will be filtered on the selected value.
Report Prompt:The scope of the report prompt is for that report only.
Suppose, you have a Prompt on Year and you want to filter only the reports (that are prompted on Year) on that page on the selected value, go for page prompt. Reports on the other pages will not be affeted by this selection.
On the other hand, if you make this as a dashboard prompt, all the reports (that are prompted on Year) on all the pages (in the same dashboard) will be filtered on the selected value.
Q.Tell me the syntax
of Ago () Function.
A:1)Ago
Function--->Calculates aggregated value as of some time period shifted from
current time.
ago(<measure>,<time
level>,<number to shift>)
Q. How do you handle Snowflake schema in BMM
Layer?
A:we will create a sinle logical table and in that we will create
multiple lts and add the columns of the descriptive dimensions in that logical
table.
Q:Creating Dimension
Levels and Keys:
A:• A dimension
contains two or more levels.
• The recommended sequence for creating levels is to create a grand total level and then create child levels, working down to the lowest level.
• Grand total level. A special level representing the grand total for a dimension. Each dimension can have just one Grand Total level. A grand total level does not contain dimensional attributes and does not have a level key.
• Level. All levels, except the Grand Total level, need to have at least one column.
• Hierarchy. In each business model, in the logical levels, you need to establish the hierarchy (parent-child levels). One model might be set up so that weeks roll up into a year.
• Level keys. Each level (except the topmost level defined as a Grand Total level) needs to have one or more attributes that compose a level key. The level key defines the unique elements in each level. The dimension table logical key has to be associated with the lowest level of a dimension and has to be the level key for that level.
Associating a Logical Column and Its Table with a Dimension Level
After you create all levels within a dimension, you need to drag and drop one or more columns from the dimension table to each level except the Grand Total level. The first time you drag a column to a dimension it associates the logical table to the dimension. It also associates the logical column with that level of the dimension. To change the level to be associated with that logical column, you can drag a column from one level to another.
After you associate a logical column with a dimension level, the tables in which these columns exist appear in the Tables tab of the Dimensions dialog box.
• The recommended sequence for creating levels is to create a grand total level and then create child levels, working down to the lowest level.
• Grand total level. A special level representing the grand total for a dimension. Each dimension can have just one Grand Total level. A grand total level does not contain dimensional attributes and does not have a level key.
• Level. All levels, except the Grand Total level, need to have at least one column.
• Hierarchy. In each business model, in the logical levels, you need to establish the hierarchy (parent-child levels). One model might be set up so that weeks roll up into a year.
• Level keys. Each level (except the topmost level defined as a Grand Total level) needs to have one or more attributes that compose a level key. The level key defines the unique elements in each level. The dimension table logical key has to be associated with the lowest level of a dimension and has to be the level key for that level.
Associating a Logical Column and Its Table with a Dimension Level
After you create all levels within a dimension, you need to drag and drop one or more columns from the dimension table to each level except the Grand Total level. The first time you drag a column to a dimension it associates the logical table to the dimension. It also associates the logical column with that level of the dimension. To change the level to be associated with that logical column, you can drag a column from one level to another.
After you associate a logical column with a dimension level, the tables in which these columns exist appear in the Tables tab of the Dimensions dialog box.
Q.Can we
join fact table with fact table?
A:NO,If we will join fact with fact then it
will consider one fact as dimension
Q. In
pivot table, sorting of column can be done?
A:YES
Q.In
pivot table, drill down and navigation is possible?
A:yes
Q.
Repository variable can have multiple values or not?
A:NO
Q.How to
pass parameters of column values from summary report to detailed report?
A:In the summary report in column formula we
will make the value interaction to navigate(navigate it to detail report) and
in the detail report make the column as is prompted.
Q.If name
of Subject area is changed and it has 80 reports. Then how to access that
reports?
A:--We can access those reports,but for the edining we have to go to
advance tab we have tro give name of the new subject area.
Q.I have two
dahboards ,say A and B.every time when I login I see dashboard A.Now I want to
make dashboard B as default dashboard so that whenever I login I see dashboard
B.
A:In
settings—My Account-->In preferences set default dashboard as dashboard B.
Q.I want to show
table headings along with column headings.
A:Go in
table properties-Table view Properties--->Display table and column heading
and select As separate rows.
Q.I want
to know the importance of Limited Values while using it for column filter
prompt.
A:To
do the constarint on prompt.suppose w ehave taken two prompts state and
city,if we will select particular state,the city under that state sould be
displayed ...for that we use limited value option for the city prompt.
Q.I have two prompts
defined on the same column.One prompt is having page scope and other propmt is
having scope for dashboard,so i want to know which prompt will be applied to
that column?
A:Dashboard
prompt which have dashboard scope will get applied to that column
Q.How to enable
sorting of columns in request on the dashboard?
A:In
presentation services -->in table view properties-->we have this option
Q.How to add multiple
navigation target to the column value?
A:Add
navigation target to the column interaction heading
Q.What is
the concept of Act As option in Dashboard Editor.
A:It acts as proxy
Q.Can
there be join between two business models?
A:NO
Q.Can
presentation catalog refer to more than one business model?
A: NO
No comments:
Post a Comment