OBIEE- Maintenance Mode

OBIEE Interview Question: What is Maintenance Mode? When and how it is used? Will users be able to save reports when it is ON?

Maintenance Mode is used for administration of Presentation Services. When Maintenance Mode is turned ON, users will not be able to save changes in Presentation Catalog- it goes in to a read-only mode at this point. This will make sure that webcat is consistent and no one is making changes to reports or saving new ones while you do your maintenance activities.  

When you as an Administrator/Developer are making changes (updating or migrating reports or archiving (taking backups)) in the Presentation Catalog in online mode, you should turn Maintenance Mode ON.

Maintenance Mode can be toggled/changed/switched from Answers/Analyses Administration page. You should be logged in as an Administrator to toggle Maintenance Mode. Click on Administration from Header Menu:

You can also go to http://{server}:{port}/analytics/saw.dll?Admin

Here on bottom left you will find a section for Maintenance and Troubleshooting. This is where you have Toggle Maintenance Mode link. Just click on this link to turn it ON or OFF.

If a user tries to make changes while Maintenance Mode is ON, she will receive the following error:

"Unable to change edit/view mode: System is in Maintenance Mode. Please try again later."

Note: In clustered mode make sure to Toggle Maintenance Mode in Presentation Services of each computer.

Oracle Informatica Interview Question and Answers

1. What is Data warehouse?

  According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.

2.         what are the types of data warehouses?

    There are three types of data warehouses

    Enterprise Data Warehouse

    ODS (operational data store)

    Data Mart

3.         What is Data mart?

            A data mart is a subset of data warehouse that is designed for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be derived from an enterprise wide data warehouse. In an independent data mart can be collected directly from sources.

4.         What is star schema?

            A star schema is the simplest form of data warehouse schema that consists of one or more dimensional and fact tables.

5.         What is snow flake schema?

            A Snowflake schema is nothing but one Fact table which is connected to a number of dimension tables, The snowflake and star schema are methods of storing data which are multidimensional in nature.

6.         What are ETL Tools?

            ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse for decision making. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database.

7.         What are Dimensional table?

            Dimension tables contain attributes that describe fact records in the fact table.

8.         What is data Modelling? 

    Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database.Data Modelling consists of various types like :

    Conceptual data modeling

    Logical data modeling

    Physical data modeling

    Enterprise data modeling

    Relation data modeling

    Dimensional data modeling.

9.         What is Surrogate key?

            Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table.

10.       What is Data Mining?

            A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information

11.       What is Operational Data Store?

            A ODS is an operational data store which comes as a second layer in a datawarehouse architecture. It has got the characteristics of both OLTP and DSS systems.

12.       What is the Difference between OLTP and OLAP?

            OLTP is nothing but OnLine Transaction Processing which contains a normalised tables .

But OLAP(Online Analtical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.

13.       How many types of dimensions are available in Informatica?

    There are three types of dimensions available are :

    Junk dimension

    Degenerative Dimension

    Conformed Dimension

14.       What is Difference between ER Modeling and Dimensional Modeling?

            ER Modeling is used for normalizing the OLTP database design.

Dimesional modeling is used for de-normalizing the ROLAP / MOLAP design.

15.       What is the maplet?

            Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mapings.

16.       What is Session and Batches?

            Session: A session is a set of commands that describes the server to move data to the target.

Batch: A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc).

17.       What are slowly changing dimensions?

    Dimensions that change overtime are called Slowly Changing Dimensions(SCD).

    Slowly Changing Dimension-Type1 : Which has only current records.

    Slowly Changing Dimension-Type2 : Which has current records + historical records.

    Slowly Changing Dimension-Type3 : Which has current records + one previous records.

18.       What are 2 modes of data movement in Informatica Server?

            There are two modes of data movement are:

Normal Mode in which for every record a separate DML stmt will be prepared and executed.

Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

19.       What is the difference between Active and Passive transformation?

            Active Transformation:An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.

Passive Transformation:A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.

20.       What is the difference between connected and unconnected transformation?

            Connected Transformation:Connected transformation is connected to other transformations or directly to target table in the mapping.

UnConnected Transformation:An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.

21.       What are different types of transformations available in Informatica? 

There are various types of transformations available in Informatica :

    Aggregator

    Application Source Qualifier

    Custom

    Expression

    External Procedure

    Filter

    Input

    Joiner

    Lookup

    Normalizer

    Output

    Rank

    Router

    Sequence Generator

    Sorter

    Source Qualifier

    Stored Procedure

    Transaction Control

    Union

    Update Strategy

    XML Generator

    XML Parser

    XML Source Qualifier

22.       What are Aggregator Transformation?

            Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).

23.       What are Expression transformation?

            Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.

24.       What are Filter transformation?

            Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.

25.       What are Joiner transformation?

            Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.

26.       Why we use lookup transformations?

            Lookup Transformations can access data from relational tables that are not sources in mapping.

27.       What are Normalizer transformation?

            Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data.

28.       What are Rank transformation?

            Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.

29.       What are Router transformation?

            Router transformationis an Active and Connected transformation. It is similar to filter transformation. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions.

30.       What are Sorter transformation?

            Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field.

31.       Name four output files that informations server creates during session running?

    Session Log

    Workflow Log

    Errors Log

    Badfile

32.       Why we use stored procedure transformation?

            A stored procedure transformation is an important tool for populating and maintaing databases.

33.       What are the difference between static cache and dynamic cache?

            Dynamic cache decreases the performance in comparision to static cache.

Static cache do not see such things just insert data as many times as it is coming

34.       Define maping and sessions?

            Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation.

Session : It is a set of instructions that describe how and when to move data from source to targets.

35.       What is a command that used to run a batch?

            pmcmd is used to start a batch.

36.       What is Datadriven?

            The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert, update, delete or reject.

37.       What is power center repository?

            The PowerCenter repository allows you to share metadata across repositories to create a data mart domain.

38.       What is parameter file?

            A parameter file is a file created by text editor such as word pad or notepad. U can define the following values in parameter file.

Maping parameters

Maping variables

session parameters.

39.       What are the types of lookup caches?

    Static cache

    Dynamic cache

    Persistent cache

    Shared cache

    Recache

40.       What are Stored Procedure transformation?

            Stored Procedure transformation is an Passive & Connected or UnConnected transformation. It is useful to automate time-consuming tasks and it is also used in error handling, to drop and recreate indexes and to determine the space in database, a specialized calculation.

41.       What is fact table?

    The centralized table in a star schema is called as fact table. Fact tables are three types

    additive

    non-additive

    semi additive

42.       What is Data warehouse?

            According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.

43.       What is Data Transformation Manager(DTM)?

            After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run.

44.       How can you define a transformation?

            A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.

45.       What are Lookup transformation?

            Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables.

46.       What are Source Qualifier transformation?

            Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc.

47.       What is difference between maplet and reusable transformation?

            Maplet consists of set of transformations that is reusable.

A reusable transformation is a single transformation that can be reusable.

48.       What are Update Strategy transformation?

            Update strategy transformation is an active and connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. You can specify how to treat source rows in table, insert, update, delete or data driven.

49.       How many types of dimensions are available in informatica?

    There are three types of dimensions.

    Star schema

    Snowflake schema

    Glaxy schema

50.       What is difference between maplet and reusable transformation?

            Maplet : one or more transformations.

set of transformations that are reusable.

Reusable transformation: only one transformation.

Single transformation which is reusable.

51.       What are different types of parsing?

    Quick parsing

    Thorough parsing

52.       What are Lookup and Fact Tables?

            A lookup (Dimension) table contains information about the entities. In general the Dimension and details objects are derived from lookup tables. A fact table contains the statistical information about transactions.

53.       What is Designer?

            Designer is the Business objects product that is intended to develop the universes. These universe is the semantic - layer of the database structure that isolates from technical issues.

54.       What is Surrogate Key?

            Surrogate keys are keys that are maintained within the data warehouse instead of keys taken from source data systems.

55.       What are the pitfalls of DWH?

    Limited value of data (Historical data not current data)

    DW solutions complicate business processes

    DW solutions may have too long a learning curve

    Costs of cleaning, capturing and delivering data

56.       How do you handle large datasets?

            By Using Bulk utility mode at the session level and if possible by disabling constraints after consulting with DBA; Using Bulk utility mode would mean that no writing is taking place in Roll Back Segment so loading is faster. However the pitfall is that recovery is not possible.

57.       What are the limitations of handling long datatypes?

            When the length of a datatype (e.g varchar2(4000)) goes beyond 4000, Informatica makes this as varchar2(2000).

58.       What are the types of OLAP?

            ROLAP (Relational OLAP) - Users see their data organized in cubes and dimensions but the data is really stored in RDBMS. The performance is slow. A storage mode that uses tables in a relational database to store multidimensional structures.

MOLAP (Multidimensional OLAP) - Users see their data organized in cubes and dimensions but the data is really stored in MDBMS. Query performance is fast.

HOLAP (Hybrid OLAP) - It is a combination of ROLAP and HOLAP. EG: HOLOs. In this one will find data queries on aggregated data as well as detailed data.

59.       What is the difference between data mart and data warehouse?

            Data mart used on a business division/department level where as data warehouse is used on enterprise level.

60.       What is Meta data?

            Data about the data, contains the location and description of data warehouse system components such as name, definitions and end user views.

61.       How does the recovery mode work in informatica?

            In case of load failure an entry is made in OPB_SERV_ENTRY(?) table from where the extent of loading can be determined.

62.       What is Aggregate Awareness?

            Aggregate awareness is a feature of DESIGNER that makes use of aggregate tables in a database. These are tables that contain pre-calculated data. The purpose of these tables is to enhance the performance of SQL transactions; they are thus used to speed up the execution of queries.

63.       What is a difference between OLTP and OLAP?

    OLTP

    It focus on day to day transaction.

    Data Stability

    Dynamic

    Highly normalized.

    Access Frequency High.

    OLAP

    It focus on future predictions and decisions

    Static until refreshed

    Demoralized and replicated data

    Medium to low.

64.       When should you use a star schema and when a snowflake schema?

            A star schema is a simplest data warehouse schema. Snowflake schema is similar to the star schema. It normalizes dimension table to save data storage space. It can be used to represent hierarchies of information.

65.       What parameters can be tweaked to get better performance from a session?

            DTM shared memory, Index cache memory, Data cache memory, by indexing, using persistent cache, increasing commit interval etc.

66.       What are the benefits of DWH?

    Immediate information delivery

    Data Integration from across, even outside the organization

    Future vision of historical trends

    Tools for looking at data in new ways

    Enhanced customer service.

67.       Is It Possible to invoke Informatica batch or session outside Informatica UI?

            PMCMD.

68.       Why we are going for surrogate keys?

    Data tables in various source systems may use different keys for the same entity.

    Keys may change or be reused in the source data systems.

    Changes in organizational structures may move keys in the hierarchy.

69.       When is more convenient to join in the database or in Informatica?        

    Definitely at the database level

    at the source Qualifier query itself

    rather than using Joiner transformation

70.       How do you measure session performance?

            By checking Collect performance Data check box.

71.       What is Dimension Table?

    It contains data used to reference data stored in the fact table.

    Fewer rows

    Primarily character data

    One primary key (dimensional key)

    Updatable data

72.       What is a database connection?

            A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Designer provides three types of connections: secured, shared, and personal.

73.       What are all the types of dimensions?

  Informational Dimension

    Structural Dimension

    Categorical Dimension

    Partitioning Dimension

Merge Statement Syntax

MERGE INTO employees e
    USING (SELECT * FROM hr_records WHERE start_date > ADD_MONTHS(SYSDATE, -1)) h
    ON (e.id = h.emp_id)
  WHEN MATCHED THEN
    UPDATE SET e.address = h.address
  WHEN NOT MATCHED THEN
    INSERT (id, address)
    VALUES (h.emp_id, h.address);

Oracle Query to check whether difference in column names of 2 tables

select column_name,DATA_TYPE from (select column_name,DATA_TYPE from all_tab_cols where table_name='FIRST_TABLE_NAME' order by internal_column_id asc)
minus
select column_name,DATA_TYPE from (select column_name,DATA_TYPE from all_tab_cols where table_name='SECOND_TABLE_NAME' order by internal_column_id asc);

Changing position of a column in ORACLE Table

SQL> create table first_table (col1 number, col2 number, col3 number);



Table created.



SQL> desc first_table
 Name                                      Null?    Type

 ----------------------------------------- -------- -------------------

 COL1                                               NUMBER

 COL2                                               NUMBER

 COL3                                               NUMBER



SQL> create table sec_table as select col3, col2, col1 from first_table;



Table created.



SQL> drop table first_table;



Table dropped.



SQL> alter table sec_table rename to first_table;



Table altered.



SQL> desc first_table;

 Name                                      Null?    Type

 ----------------------------------------- -------- -------------------

 COL3                                               NUMBER

 COL2                                               NUMBER

 COL1                                               NUMBER



SQL> 

Alter session set nls_date_format

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

Payables Open Interface

AP Invoice Interface is concerned with the creation of payable invoices in the Oracle System. Standard Payable invoices are created in the system for the PO sent across to the supplier and invoice details received for the same.

Payable invoices can be created manually by entering from the Invoice screen but in business having recurring transactions opt for auto invoice creation. This mechanism involves populating the interface tables with the invoice table and run the payables import program to create the invoice.


Table Details:

AP Invoice Interface tables

1.AP_INVOICES_INTERFACE

2.AP_INVOICE_LINES_INTERFACE


AP Invoice Base Tables:

1. AP_INVOICES_ALL

2.AP_INVOICE_DISTRIBUTIONS_ALL

3. AP_PAYMENT_SCHEDULES_ALL


Error table:1.AP_INTERFACE_REJECTIONS2.AP_INTERFACE_CONTROLS


Users can use the Payables Open Interface Import program to create Payables invoices from invoice data in the Payables Open Interface Tables.  Payables Open Interface Tables need to be populated with invoice data from the following sources:

        Supplier EDI invoices (ASC X12 810/EDIFACT INVOIC) transferred through Oracle EDI Gateway

        Invoices from other accounting systems with a custom SQL*Loader program

        Credit card transactions you have transferred using the Credit Card Invoice Interface Summary

After the interface tables are populated users need to submit

    The Payables import program to create payables invoices.Enter the report parameters.  In the Source field, select the source name from the list of values. If your records have a Group and you want to import invoices for only that group, enter the Group. This will allow you to import smaller sets of records concurrently for the same source, which will improve your performance. If you use batch control, enter a Batch Name.

Debugging Interface Errors


After the interface program completes invoices will be created in the system. For the records failing the validations no invoices will be created and the records will be errored out in the interface.

Some of the most fatal errors are

    No supplier or supplier site

    The invoice number is a duplicate

If the invoice level information is correct, Payables will validate all values at the line level, and the rejections report will list all line level problems. If a distribution is rejected, the whole invoice is rejected.You can correct the data in one of the following ways:


    Use the Open Interface Invoices window to correct problems directly in the Payables Open Interface tables.

Invoice Validation


Once the Invoices have been created invoice validation needs to be done so that invoices can be processed further to make payments and transfer to GL. For this we need to either manually validate individual invoices from the Invoice Screen or run the Invoice Validation Program. This activity will validate the invoices and allow further processing, In case invoices fail in validation then the invoices will be put on hold . the user can see the hold details by pressing the "HOLDS" button on the invoice screen. at the backend hold details will be stored in the table : ap_invoice_holds

SQL query to find Open/Close Periods in Oracle Apps R12

Query to find the Gl Set of Books.

To find SET_OF_BOOKS_ID:

SELECT * FROM gl_sets_of_books

Inventory

SELECT DISTINCT opu.name AS operating_unit
                , per.organization_id AS inv_org_id
                , par.organization_code AS inv_org_code
                , org1.name AS Organization_name
                , per.period_name
                , per.period_year
                , flv.meaning AS status
    FROM org_acct_periods per
       , fnd_lookup_values flv
       , mtl_parameters par
       , hr_all_organization_units org1
       , hr_all_organization_units_tl otl
       , hr_organization_information org2
       , hr_organization_information org3
       , hr_operating_units opu
   WHERE 1 = 1
     AND flv.lookup_type(+) = 'MTL_ACCT_PERIOD_STATUS'
     AND flv.enabled_flag(+) = 'Y'
     AND per.organization_id = par.organization_id
     AND flv.lookup_code(+) =
            DECODE (
               NVL (per.period_close_date, SYSDATE)
             , per.period_close_date, DECODE (
                                         per.open_flag
                                       , 'N', DECODE (summarized_flag
                                                    , 'N', 65
                                                    , 66)
                                       , 'Y', 4
                                       , 'P', 2
                                       , 4)
             , 3)
     AND flv.language = 'US'
     AND UPPER (flv.meaning) != 'CLOSED'
     AND per.organization_id = org1.organization_id
     AND org1.organization_id = otl.organization_id
     AND org1.organization_id = org2.organization_id
     AND org1.organization_id = org3.organization_id
     AND org2.org_information_context = 'Accounting Information'
     AND org3.org_information_context = 'CLASS'
     AND org3.org_information1 = 'INV'
     AND org3.org_information2 = 'Y'
     AND org2.org_information3 = opu.organization_id
     AND PER.PERIOD_NAME = '&Period_Name'
     and opu.set_of_books_id = '&SOB'
ORDER BY opu.name
       , per.organization_id;

To Check whether Periods of AP/AR/GL/FA/PO is closed?

  SELECT DISTINCT (SELECT sob.NAME
                     FROM gl_sets_of_books sob
                    WHERE sob.set_of_books_id = a.set_of_books_id)
                     "SOB_Name"
                , a.period_name "Period_Name"
                , a.period_num "Period_Num"
                , a.gl_status "GL_Status"
                , b.po_status "PO_Status"
                , c.ap_status "AP_Status"
                , d.ar_status "AR_Status"
                , e.fa_status "FA_Status"
    FROM (SELECT period_name
               , period_num
               , DECODE (closing_status
                       , 'O', 'Open'
                       , 'C', 'Closed'
                       , 'F', 'Future'
                       , 'N', 'Never'
                       , closing_status)
                    gl_status
               , set_of_books_id
            FROM gl_period_statuses
           WHERE application_id = 101
             AND UPPER (period_name) = UPPER ('&period_name')
             AND set_of_books_id = '&sob') a
       , (SELECT period_name
               , DECODE (closing_status
                       , 'O', 'Open'
                       , 'C', 'Closed'
                       , 'F', 'Future'
                       , 'N', 'Never'
                       , closing_status)
                    po_status
               , set_of_books_id
            FROM gl_period_statuses
           WHERE application_id = 201
             AND UPPER (period_name) = UPPER ('&period_name')
             AND set_of_books_id = '&sob') b
       , (SELECT period_name
               , DECODE (closing_status
                       , 'O', 'Open'
                       , 'C', 'Closed'
                       , 'F', 'Future'
                       , 'N', 'Never'
                       , closing_status)
                    ap_status
               , set_of_books_id
            FROM gl_period_statuses
           WHERE application_id = 200
             AND UPPER (period_name) = UPPER ('&period_name')
             AND set_of_books_id = '&sob') c
       , (SELECT period_name
               , DECODE (closing_status
                       , 'O', 'Open'
                       , 'C', 'Closed'
                       , 'F', 'Future'
                       , 'N', 'Never'
                       , closing_status)
                    ar_status
               , set_of_books_id
            FROM gl_period_statuses
           WHERE application_id = 222
             AND UPPER (period_name) = UPPER ('&period_name')
             AND set_of_books_id = '&sob') d
       , (SELECT fdp.period_name
               , DECODE (fdp.period_close_date, NULL, 'Open', 'Closed')
                    fa_status
               , fbc.set_of_books_id
            FROM fa_book_controls fbc, fa_deprn_periods fdp
           WHERE fbc.set_of_books_id = '&sob'
             AND fbc.book_type_code = fdp.book_type_code
             AND UPPER (fdp.period_name) = UPPER ('&period_name')) e
   WHERE a.period_name = b.period_name(+)
     AND a.period_name = c.period_name(+)
     AND a.period_name = d.period_name(+)
     AND a.period_name = e.period_name(+)
     AND a.set_of_books_id = b.set_of_books_id(+)
     AND a.set_of_books_id = c.set_of_books_id(+)
     AND a.set_of_books_id = d.set_of_books_id(+)
     AND a.set_of_books_id = e.set_of_books_id(+)
ORDER BY 1;

OBIEE 11G Creating Column Selector and View Selector Views

A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically change the columns that display in results. This will allow you to analyze data along several dimensions. By changing the measure columns, you can dynamically alter the content of the analyses you have created.
To create a Column Selector and View Selector views, perform the following steps:

1 .	a. Open the Regional Revenue analysis in the Analysis Editor. The Results tabbed page appears.   b. Click the New View icon and select Other Views > Column Selector.
2 .	The Column Selector view appears. Drag the Column Selector view above the Title view. Click the Edit View icon for the Column Selector view. The Column Selector editor appears.
3 .	a. Select the Include Selector C50 Region check box. b. In the Label (optional) Choices text box, enter Choose a column:. c. With Column still selected, double-click the following columns to add to the selector: P4 Brand, P3 LOB, and P2 Product Type. d. Click Done. The Compound Layout appears:
4 .	a. Click the Column Selector drop-down list and select P3 LOB: b. The values change appropriately. Note, however, that because you set a custom heading for the C50 Region column earlier, the custom heading is still displayed for the column. c. Save the analysis.
5 .	Now you will add the View Selector view. A View Selector view provides a drop-down list from which users can select a specific view of analysis results from among saved views. A View Selector view is analogous to a storage container, because it holds other views that have been selected in the editor for display. a. Perform these steps before adding the View Selector view: Delete the Title view from the Compound Layout. Set the Column Selector to display the C50 Region column, which is the default. Then delete the Column Selector view from the Compound Layout. Add a Graph view - Vertical Bar graph. These changes will allow you to showcase the analytic data-driven views. Regional Revenue should look like this:
6 .	a. Click the New View icon on the toolbar and select Other Views > View Selector. b. Drag the View Selector view to the right of the Table view. c. Click the Edit View icon for the View Selector view.
7 .	a. The View Selector editor appears.In the Caption text box, enter Choose a view:. b. In the Available Views list, select the Table and Graph views and click the shuttle icon to move them to the Views Included list. A preview appears at the bottom of the editor. Note that these views are data-driven views, unlike the Column Selector and Title views, which were deleted from the Compound Layout. c. Click Done.
8 .	The Compound Layout should look like this when the Graph view is selected: Do not save your changes to the analysis.