nasspecialists.blogg.se - How to create new treemap chart in obiee

#How to create new treemap chart in obiee how to#
#How to create new treemap chart in obiee windows#

You can ignore all other warnings from the imp command, including one that says "Unexpected end of export file encountered". Set NLS_LANG=American_America.WE8ISO8859P1

#How to create new treemap chart in obiee windows#

For instance, on Windows you can type the following in the DOS window before issuing the above imp command again: If the above command fails due to character set related issues (such as IMP-00016 imp: charset conversion error), you may need to set the NLS_LANG environment variable to American_America.WE8ISO8859P1 temporarily. Imp mvdemo/mvdemo file=mvdemo.dmp full=y ignore=y Open a command window, change the directory to the location of mvdemo.dmp, and use the following command to import the data into user mvdemo: You can import it into an Oracle 10g or 11g database. This is a database dump file exported from an Oracle database. In this example mvdemo.dmp is copied to D:\mvdemo\mvdemo11R1. GRANT CONNECT, RESOURCE, CREATE VIEW TO mvdemo IDENTIFIED BY mvdemo Ĭopy mvdemo.dmp to a location on your machine. Use the following script for reference:ĬREATE USER mvdemo IDENTIFIED BY mvdemo DEFAULT TABLESPACE USERS Sign in to SQL*Plus as a system user and create a database user named mvdemo. All instructions for accessing and importing these schemas are provided in this tutorial. In this tutorial you use a Map Viewer demo schema, mvdemo, and an OBI schema, obieemap. To import the required schemas for this OBE into your Oracle database, perform the following steps. Please note that this repository will not be ready for building analyses in OBI Presentation Services until after you complete the first topic in this OBE: Importing Schemas to Your Database.

Use Enterprise Manager 11g Fusion Middleware Control to upload the OBIEEMAP repository (obieemap.rpd) located here.

Have access to or have Installed Oracle Business Intelligence 11g.

Before starting this tutorial, you should: As a result you may need to modify some steps in this tutorial to match your environment. Please note that this tutorial was built using a Windows environment with all required components installed on a single machine. It is assumed that you know how use Enterprise Manager 11g Fusion Middleware Control to upload an OBI repository. This tutorial does not provide instructions for uploading the pre-built OBI repository. All instructions for accessing and importing the schemas are provided in this tutorial. This tutorial uses a sample map data schema, a pre-built OBI schema, and a pre-built OBI repository. For more detailed information about Map Builder and Map Viewer, please refer to the Resources section at the end of this OBE. Please note that this tutorial provides only a basic introduction to Oracle Map Builder and Oracle Map Viewer for the purposes of building a map and then integrating the map into OBI.

#How to create new treemap chart in obiee how to#

In this Oracle by Example (OBE) tutorial you learn how to use Oracle Map Builder to build a map, use Oracle Map Viewer to bring the map online for integration with Oracle Business Intelligence (OBI), and then embed the map into a Map view in an OBI analysis. This tutorial covers using Oracle Map Builder and Oracle Map Viewer to build and embed maps for use in Oracle Business Intelligence analyses and dashboards.