How To Install Efashion Universe Images
How To Install Efashion Universe Quotes. If the eFashion universe does not appear in the list then click on the More button and select the.
C & Efashion
This first lesson presents key concepts and vocabulary that are important to understand before proceeding to the next lesson. Here you will learn about;. Web Intelligence concepts. Web Intelligence core functionality Web Intelligence concepts Accessing information with Web Intelligence With Web Intelligence, you can query databases using everyday business terms, and using an easy-to-use interface. You can create simple or very complex reports and share the information you display with other colleagues. As part of your job you make decisions all the time and therefore need the right information at your fingertips to help you make the right decisions.
You want to access information using your everyday business vocabulary without having to understand anything about the technical way the information is stored. Once you have anaylsed information, you also need to be able to share it with your colleagues. Web Intelligence allows you to access, analyse and share corporate data very easily. To access BusinessObjects Web Intelligence, you must first and launch BOXI from the 'BusinessObjects Reporting' channel which is located on the Admin tab. This process is explained in more detail in Lesson 2.
Understanding the semantic layer The BusinessObjects universe is the semantic layer that isolates you from the technical complexities of the databases where your corporate information is stored. Because universes are based on business terminology that is familiar to you and shared throughout the organisation, universes allow you to create queries and get information using your own everyday terms. The terms you need to be familiar with in order to understand how this semantic layer functions are;. Universe. Object. Class Universes A universe maps to the data in the database, but uses everyday terms that describe your business environment.
This means that you can select exactly the data that interests you using your own business terminology. Universes are created by a universe designer using BusinessObjects Designer. The designer then makes universes available to you and other users so that you can access the data through an intuitive, user-friendly interface.
Universes are made up of objects, classes and pre-defined query filters. Objects The elements within the universe that you use to create reports are called objects Classes Objects that represent similar types of data are grouped into classes. The above diagram shows the eFashion universe, which is the universe used throughout these lessons to build queries and create Web Intelligence documents. Classes are logical groupings of objects and they are indicated by the folder icon. Object are elements that map to a set of data in a relational database, but using business terms. For example, one of the classes in the eFashion universe is the Store class, and a few of the objects in the Store class include State, City, and Store name.
Introduction For years, the BusinessObjects products have been demonstrated with the eFashion sample data set. It came in the format of a Microsoft Access database on top of which a pre-built universe was running using an ODBC connection. From there, numerous sample reports or dashboards could be built and illustrate key features of the Semantic Layer and BI client tools. This article presents the steps to set up the same data set within HANA and BI 4.0, therefore put together a demo environment for BI 4.0 on HANA. Highlights of this sample.
the universe is a relational universe of the new format (.UNX) that was released with BI 4.0. the data set does not contain the aggregate tables anymore, it has the master data tables and one fact table (SHOPFACTS). The aggregates are defined by Analytic Views to be imported into HANA after the tables were loaded. the universe is still leveraging the aggregateaware function to decide at runtime which aggregate to report off Download the project files. The files required for this project are available from here:. Extract the archive file into a local folder accessible from HANA Studio and Information Design Tool Load the data into HANA.
From the local folder where you extracted the files, use an FTP client tool to copy the folder dataset/index into the work directory of your HANA instance on the HANA appliance. It would typically be /usr/sap//HDB00/work. Open the HANA DB Studio and log on with the SYSTEM user to the HANA Instance you will work with. From the navigator pane, expand the system and right click on 'Catalog' to select 'Import.' . Specify the location on the HANA appliance where you copied the files, typically the work directory.
Use the following list of tables and click 'Add': EFASHIONTUTORIAL.ARTICLELOOKUP,EFASHIONTUTORIAL.ARTICLECOLORLOOKUP, EFASHIONTUTORIAL.CALENDARYEARLOOKUP,EFASHIONTUTORIAL.OUTLETLOOKUP, EFASHIONTUTORIAL.SHOPFACTS. Select 'Catalog + Data' and set the number of parallel Threads to 4 (should not be higher than the number of cores on your HANA appliance). Click on Finish. The job should execute in a few seconds. From the navigator pane, right click on 'Catalog' and select 'Refresh'. The new schema 'EFASHIONTUTORIAL' should now appear.
Efashion Universe
Alternative method: if the steps below fail for some unknown reason, run the SQL statements below from an SQL Editor window. Before you execute it, you will need to update the path to the.ctl files in each 'IMPORT FROM' statement. Hi Patrice, Its really an helpful document but one question is. The content which is downloaded from doesnt have the.ctl files and hence the following SQL scripts are failing to execute IMPORT FROM '/usr/sap/CSA/HDB00/work/EFASHIONTUTORIAL/AR/ARTICLELOOKUP/data.ctl'; IMPORT FROM '/usr/sap/CSA/HDB00/work/EFASHIONTUTORIAL/AR/ARTICLECOLORLOOKUP/data.ctl'; IMPORT FROM '/usr/sap/CSA/HDB00/work/EFASHIONTUTORIAL/CA/CALENDARYEARLOOKUP/data.ctl'; IMPORT FROM '/usr/sap/CSA/HDB00/work/EFASHIONTUTORIAL/OU/OUTLETLOOKUP/data.ctl'; IMPORT FROM '/usr/sap/CSA/HDB00/work/EFASHIONTUTORIAL/SH/SHOPFACTS/data.ctl'; Could you please clarify Rgds, Murali. Hi, I am have managed to import all tables except EFASHIONTUTORIAL.SHOPFACTS & EFASHIONTUTORIAL.CALENDARYEARLOOKUP tables. I get the error like below SAP DBTech JDBC: 2: general error: EFASHIONTUTORIAL.SHOPFACTS not found in import directory.
Folder names could be modified by WinSCP transfer SAP DBTech JDBC: 2: general error: EFASHIONTUTORIAL.SHOPFACTS not found in import directory. Folder names could be modified by WinSCP transfer I have placed the index folder as advised in work folder in the appliance.
Not sure why its not allowing to import on these 2 folders.