Skip to main content

Map viewer in OBIEE 11g - Part 1



Map viewer – Part 1





Map View is also one type of view in Oracle business intelligence.

Map view is used to locate the Country with that measure values.

Oracle Map viewer is a java based web application used for representing maps with in a web page.

It can be deployed to most J2EE application servers (such as OC4J, Apache Tomcat, Web logic etc.).

Web-based applications such as OBIEE 11g can embed maps within their web pages simply by making calls to Oracle Map Viewer; there are many different functions (APIs) available.

Steps to implement map view:

1. Check the privileges for map view according to the corresponding users and roles.

1.1 Login to presentation side as weblogic, go to administration under that go to “Manage Map data”.

1.2 If the page didn’t open then you don’t have the privileges to access map view.

1.3 Go to “manage privileges” and check in the section of “Admin: General”-manage Map data.

1.4 Give access to the “Manage Map Data” in right side.








2. Download the pre- built sample data “MVDEMO” as dump from oracle site

Click on the link

http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index-100641.html







3. Let’s create one schema with user-defined name or you can use the same name as “MVDEMO”.

4. Unzip and Import the downloaded dump to this user.

5. Command to create user and Importing dump follow this “User Creation” & “ Importing dump








6. Also Import the sample data set to this user.

7. Check in the data base sql developer by connecting the user whether all the tables and columns with data are imported or not by following this link “Create Connection for the user”.



Once Import done then go to the admin view of Map viewer to connect the database to OBIEE.



8. Open the page http://localhost:9704/mapviewer/faces/home.jspx” login as “weblogic”.

9. Click on “Admin” on the right side top of the page you will get the log in username and password provider to give the details of user credentials.

















10. You will get the home page to create data source for creating a connection to BI.







11. Click on “Datasources”, you will get a page with “Create a dynamic data source” give all the credentials of database and username, password.








Name: MVDEMO

Based on: JDBC URL or TNS Name or J2EE DS (I Used here is “JDBC URL” and “TNS Name”)

Host: <Host name of the database or IP address of the database system located> Ex.192.168.1.13

Port; 1521

SID: orcl

User: mvdemo

Password: ******

#Mappers: 3 (Default) – You can change this.

Max Connections: 100(default) – 0 is for maximum connection more than 100.










12. Once added then check in the list of existing data sources.









13. Select manage Map Tile Layers to check the base map layers and background details for the data sources.














14. By default Customer Map and Demo Map will come based on the MVDEMO database.

Additionally we can add more layers like BING Map and Google Map, more.

15. By click on “Create” under “Manage Map Tile Layer” you can add 5 tile layers.

16. Types of map source are

a. Internal

b. External

c. Oracle eLocation

d. Bing Maps

e. Google Maps









17. Adding BING Maps for example follow the steps.

18. Click on create select BING MAPS under the drop down list.

19. Click Continue to create.







20. Assign the name for the Map layer for example bing_map1

21. Select the data source available.





22. Under properties check the details about bing-maps url, key, map type value, map type names.

It will come as default and give submit to save the layer.







23. Check in the Manage tile layers list, whether newly created bing_map1 layer is added or not.

24. Select the layer and click on bring online tab to bring the layer into online view.







25. Select views map/managed tiles to check the status.





One window will open for viewing map, click on show map to view.





















Comments

  1. How do you enable the Area Selection Tool and the prefetch tile operations using Bing Maps?

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope