Applies to:
SAP BusinessObjects Business Intelligence Platform, SAP BusinessObjects Semantic Layer and SAP BusinessObjects Web Intelligence.
Summary
This article provides step by step process of creating universe on flat file using Information Design Tool (IDT). In addition it also mentions the details of key points to be considered while creating flat file universe through IDT. The content in this article is intended for semantic layer users and designers those who would wish to create flat file universes and provide developers access via web Intelligence etc.
Note: Flat file in this article refers to .CSV, .Txt and other supported files.
Author: Mallikarjuna Chary Narayandas
Company: Gyansys Inc.
Created on: June 22, 2013
Author Bio
The author has worked on several SAP BusinessObjects projects and has experience on using all the SAPBusinessObjects Business Intelligence platform tools. Author has experience on working with SAPBusinessObjects mobile including designing and accessing BusinessObjects content (Web Intelligence Reports, Crystal Reports, Dashboards, Analysis and Information Spaces) through IPAD / IPhone / Android.
Introduction
This article provides step by step process of creating universe on flat file using Information Design Tool (IDT). In addition it also mentions the details of key points to be considered while creating flat file universe through IDT. The content in this article is intended for semantic layer users and designers those who would wish to create flat file universes and provide developers access via web Intelligence etc. Below are few key drivers of choosing a Flat file universe over web intelligence rich client report creation of flat files.
Step By Step Process of Flat File Universe Creation
Note: Designer should have been already connected to BO server on IDT or else he may have to do it at this step.
Now the that the UNX universe created would work fine with local connection for rich client reports, if designer wants this universe to be allowing queries from BI Launchpad to run fine without any error messages then he has to update the connection published to repository using steps below.
Note1: This file location on BusinessObjects server would be different if the BusinessObjects server is deployed on Unix or Windows OS.
Note2: Since designer is updating the connection from repository resources, No connection publish step is required.
Even though the connection is updated with right folder location pointing to BusinessObjects server, when designer performs Test connection it returns the error message as below and data preview of query would also result in an error message as below. However, the query built from web intelligence through BI launch pad runs fine and users can create and execute reports on this Flat File universe.
References
SAP BusinessObjects Business Intelligence Platform
SAP BusinessObjects Web Intelligence.
SAP BusinessObjects Web Intelligence ... | SCN
Disclaimer and Liability Notice
This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |