Dimension in Database

Creating Dimensions in Database

In the post will see how to create dimensions in your database.Here Essbase is already installed in the server. we just connecting to it.

So hold on tight...

Creating Dimension in database -

· Go to your Application -> Database -> Outline,

· Right Click on Outline : <Database name> (Active Alias Table: Default) and select Add Child. Like this add as many dimension you want. Note that Only Dimension has to be created as of now. Members will be created in Rule File or right click dimension and click Add child. Save it!

Comments

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...

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 ...

Docker with Essbase

Oracle Essbase with Docker What is Docker: Docker is a tool which put together an application and all its dependencies together in the form of containers. This containerization aspect of Docker ensures that the application works in any environment. Docker is an open – source project that automates the deployment of application inside software container. Docker containers wrap up a piece of software in a complete file system that contains everything it needs to run. Docker vs VMs with reference to Essbase: Traditionally we were using VMs, Following are some issues in VMs with compare to Docker. • Large image size: Essbase VMs tend to have in at 50-70GB, depending on what all is installed. • Difficulties starting up services: When moving between networks, such as from home to a client network to the coffee shop or wherever, I frequently run into networking issues that are hard to troubleshoot and usually resolved by restarting the entire VM (...

Hyperion At Ease

Search This Blog