Posts

BEx Ad Hoc Query Fundamentals

BEx Ad Hoc Query Fundamentals provides key terms and concepts BI Power Users need to understand prior to creating an ad hoc query in BEx Query Designer.

BEx Ad Hoc Query Fundamentals are organized in multiple sections.  Each section will build on the concepts covered in previous Fundamentals topics:

  • BEx Ad Hoc Query Fundamentals – Part I: Provides an overview of basic key terms and concepts BI Power Users need to understand prior to creating a basic ad hoc query in BEx Query Designer. This section covers key terms and concepts of Key Figures, Dimensions, Characteristics, Free Characteristics, Attributes and Filters
  • BEx Ad Hoc Query Fundamentals – Part II: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I. This section covers key terms and concepts of Key Figure Properties, Restricted Key Figures, Caharacteristic Properties and Variables
  • BEx Ad Hoc Query Fundamentals – Part III: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I and Part II. This section covers key terms and concepts of Compound Characteristics, Hierarchy Characteristics, Hierarchy Characteristic Properties, Hierarchy Variables, Basic Formulas, Ad Hoc Query Dates, Key Date

Read more →

/0 Comments/by

How to Load a Flat File in SAP BI Integrated Planning Using BEx

SAP NetWeaver BI Integrated Planning now has the ability to allow users to upload data directly into transactional cubes. The solution outlined in this paper provides a how-to guide to use flat file upload functionality in BEx. It also shows step-by-step how to use a query to preview the data uploaded before deciding whether to save (write) the data to the target cube. This is basically replicating the BPS file upload functionality in IP. The solution depicted in this paper provides the user with the familiarity of BEx, but with the flexibility of Integrated Planning. Read more →

/1 Comment/by