Skip to main content

Smart View connection

Smart View connection

Before connecting Oracle smart view with essbase. You need to download it from oracle website and install it. installation is easy process..next next next ...finish...
Below is the link for downloading smart view.
https://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-2412371.html

Smart-view Connection –
  1. Download Excel and Oracle Smart-view from the web.
  2. Open MS Excel – Go to File -> Options

  1. Go to Add-in
                  

  1. Go to Mange and select COMM Add-ins and Click Go


  1. Select Oracle Smart View for office and Click OK

  1. After the above step you see a SMARTVIEW option in the last of Excel ribbon. Click it!

  
  1. Now to connect the smart-view with the Essbase server. Click the Panel option. You see an Smart-view panel on the right side. Click the Shared Connections.
  


  1. After clicking Shared Connections option on the Smart-View Panel. A dialog box will be displayed asking your username and password of Essbase.

  1. After entering your username and password. On the smart view panel your Shared connection will be displayed. Select Oracle® Essbase in the drop down option. Your EssbaseCluster will be displayed.
  

  1. Click the EssbaseCluster and all your Essbase applications will be displayed. Double click your Application and Double click your database name. Some operation option will be POP up in the downside of the SMARTVIEW panel. 

 
  1. Click the Ad hoc analysis and VOLLA! Your application is ready to use in Smart-view. All your dimension will be displayed on the excel spread sheet.
  









Comments

Post a Comment

Popular posts from this blog

Business Intelligence

Business Intelligence You must be wondering what is the above imageor title is about. Yeah, it is about the first project I get into. Where the client was using all the above process to generate a report, which will help them to manage their financial planning. So now you must be having an idea that what this blog is about i.e; using Business Intelligence, EPM, ETL and ERP how the financial decisions are taken. Here the client uses the different processes to achieve their goals. So let’s dive in and try to understand the process.  Note - In this blog, you will get an overview of each process and its high-level architecture. Enterprise Resource Planning -  Firstly let's start with  Enterprise resource planning (ERP),  most of the companies store data through ERP. It is a process whereby a company manages and integrates the important parts of its business. ERP system stores both operational and non – operational data. An ERP man...
8 comments
Read more

Hyperion Essbase - Administration Services

Administration Services in Essbase. In this blog i m going to briefly discuss about Hyperion Essbase Administration Services. It is this core part of Essbase for managing data in the database. Introduction about Administration Services in Essbase  –   It’s a cross-platform administration tool for Essbase It consists of three tiers Administration Services Architecture – ·         Client Tier (Administration Services Console) – it’s a Java-based client console also called as EAS console (Essbase Administration Services Console). It’s a UI to manage Essbase Environment.              Middle Tier (Administration Server) – it’s a Java-based server maintains communication, session, and security information between console and Essbase server. It uses HTTP and TCP/IP protocols to communicate.        Database Tier (Essbase Servers) – One or more Essbase servers ...
1 comment
Read more