System: Bluetelligence System

System: bluetelligence System

MockuBaseDocument

Table of contents

1 General Information 2

2 Queries 2

2.1 Overview 2

2.2 Properties 2

2.3 Query Scripts 2

2.3.1 Costs 2

2.3.2 Orders 3

2.3.3 Product Overview per Region 3

3 Available objects 3

3.1 Arranged by Query 3

3.2 Object details 3

3.3 Merge dimension details 8

4 Variables 8

4.1 Overview 8

4.2 Variable details 8

5 Reports 9

5.1 Structure 9

5.2 Structure with axes 10

6 Conditional formats 11

1  General Information

Technical name / MockuBaseDocument
Description / This is the Description of the "MockupBaseDocument"
ID / d47443d5-e26a-4086-9c89-8b9fbc9b8cfb
CUID / Fpvfj1ROfA4AqiQAAAA3Q1MAoNPBApds
Path / /Root Folder/Development
Last Modified / 16.12.2014 18:28:11
Scheduled / false
State / Unused
Created by / Administrator
Last modified by / Administrator
Size / 54901
Refresh on open / False
Last modified on / 16.12.2014 17:28:10
Enable query stripping / True
Content alignment / ltr
Permanent regional formatting / False
Locale / de_DE
Content locale / en_US
Merge prompts / True
Extend merged dimension values / False
Created on / 16.12.2014 07:30:35
Last refreshed on / 16.12.2014 12:33:07
Duration of previous refresh [s] / 7
Use query drill / False
Hide warning icons in charts / False

2  Queries

2.1  Overview

Name
Costs (DS_DEMO_FULL)
Orders (DS_DEMO_FULL)
Product Overview per Region (DS_DEMO_FULL)

2.2  Properties

Name / Max rows retrieved / Max retrieval time (s) / Retrieve duplicate rows / Retrieve empty rows / Enable query stripping / Allow other user to edit query / Reset contexts on refresh
Costs / 0 / 0 / True / False / True / True / True
Orders / 0 / 0 / True / False / True / True / True
Product Overview per Region / 0 / 0 / True / True / False / True / True

2.3  Query Scripts

2.3.1  Costs

Result 1
No Query Script

2.3.2  Orders

Result 1
No Query Script

2.3.3  Product Overview per Region

Result 1
No Query Script

3  Available objects

3.1  Arranged by Query

Objects
Costs (DS_DEMO_FULL)
Sales Organization (Dimension, 0D_NW_SORG)
Product Costs (Measure, 9IROG4JRJS0F1KBPD06PV0UD4)
Transport Costs (Measure, 9IROG4JRJS0F1KBPD06PV1708)
Sales Organization - Key (Detail, 0D_NW_SORG.Key)
Orders (DS_DEMO_FULL)
Sales Organization (Dimension, 0D_NW_SORG)
Open order quantity (Measure, 9IROG4JRJS0F1KBPD06PV0HQ0)
Open order stat curr (Measure, 9IROG4JRJS0F1KBPD06PV0O1K)
Sales Organization - Key (Detail, 0D_NW_SORG.Key)
Open order quantity Formatted Value (Detail, 9IROG4JRJS0F1KBPD06PV0HQ0.FormattedValue)
Open order stat curr Formatted Value (Detail, 9IROG4JRJS0F1KBPD06PV0O1K.FormattedValue)
Product Overview per Region (DS_DEMO_FULL)
Plant (Dimension, 0D_NW_PLANT)
Product (Dimension, 0D_NW_PROD)
Product Category (Dimension, 0D_NW_PROD__0D_NW_PRDCT)
Product Group (Dimension, 0D_NW_PROD__0D_NW_PRDGP)
Region (Dimension, 0D_NW_REGIO)
Net Value stat curr (Measure, 9IROG4JRJS0F1KBPD06PV052W)
Open order stat curr (Measure, 9IROG4JRJS0F1KBPD06PV0O1K)
Product Costs (Measure, 9IROG4JRJS0F1KBPD06PV0UD4)
Transport Costs (Measure, 9IROG4JRJS0F1KBPD06PV1708)
Merged dimensions
Sales Organization
Sales Organization Costs Dimension
Sales Organization Orders Dimension

3.2  Object details

Net Value stat curr
Query / Product Overview per Region
Type / Numeric
Qualification / Measure
Description / Net Value stat curr
Tables / Block 2, Block 4
Charts
Standalone cells
Alerters / Highest Lowest Net Value
Variables / Max Net Value stat curr, Min Net Value stat curr
Merged dimensions
Open order quantity
Query / Orders
Type / Numeric
Qualification / Measure
Description / Open order quantity
Tables / Default Table Orders
Charts
Standalone cells
Alerters
Variables / Average Open Amount per Order
Merged dimensions
Open order quantity Formatted Value
Query / Orders
Type / String
Qualification / Detail
Description
Tables / Default Table Orders
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Open order stat curr
Query / Orders
Type / Numeric
Qualification / Measure
Description / Open order stat curr
Tables / Default Table Orders
Charts
Standalone cells
Alerters
Variables / Average Open Amount per Order
Merged dimensions
Open order stat curr
Query / Product Overview per Region
Type / Numeric
Qualification / Measure
Description / Open order stat curr
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Open order stat curr Formatted Value
Query / Orders
Type / String
Qualification / Detail
Description
Tables / Default Table Orders
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Plant
Query / Product Overview per Region
Type / String
Qualification / Dimension
Description / Plant
Tables / Block 4
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Product
Query / Product Overview per Region
Type / String
Qualification / Dimension
Description / Product
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Product Category
Query / Product Overview per Region
Type / String
Qualification / Dimension
Description / Product Category
Tables / Block 4
Charts
Standalone cells / =[Product Category]
Alerters
Variables
Merged dimensions
Product Costs
Query / Costs
Type / Numeric
Qualification / Measure
Description / Product Costs
Tables / Default Table Costs
Charts
Standalone cells
Alerters
Variables / Total Costs
Merged dimensions
Product Costs
Query / Product Overview per Region
Type / Numeric
Qualification / Measure
Description / Product Costs
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Product Group
Query / Product Overview per Region
Type / String
Qualification / Dimension
Description / Product Group
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Region
Query / Product Overview per Region
Type / String
Qualification / Dimension
Description / Region
Tables
Charts
Standalone cells / =[Region]
Alerters
Variables
Merged dimensions
Sales Organization
Query / Costs
Type / String
Qualification / Dimension
Description / Sales Organization
Tables / Total Costs, Default Table Costs
Charts / Total costs Chart
Standalone cells
Alerters
Variables
Merged dimensions / Sales Organization
Sales Organization
Query / Orders
Type / String
Qualification / Dimension
Description / Sales Organization
Tables / Default Table Orders, Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions / Sales Organization
Sales Organization - Key
Query / Costs
Type / String
Qualification / Detail
Description / Key
Tables / Default Table Costs
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Sales Organization - Key
Query / Orders
Type / String
Qualification / Detail
Description / Key
Tables / Default Table Orders
Charts
Standalone cells
Alerters
Variables
Merged dimensions
Transport Costs
Query / Costs
Type / Numeric
Qualification / Measure
Description / Transport Costs
Tables / Default Table Costs
Charts
Standalone cells
Alerters
Variables / Total Costs
Merged dimensions
Transport Costs
Query / Product Overview per Region
Type / Numeric
Qualification / Measure
Description / Transport Costs
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Merged dimensions

3.3  Merge dimension details

Sales Organization
Type / String
Qualification / Dimension
Description / Sales Organization
Source dimensions / Sales Organization Dimension Costs, Sales Organization Dimension Orders
Tables
Charts
Standalone cells
Alerters
Variables

4  Variables

4.1  Overview

Name / Type / Qualification
Average Open Amount per Order / Numeric / Measure
Max Net Value stat curr / Numeric / Measure
Min Net Value stat curr / Numeric / Measure
Total Costs / Numeric / Measure

4.2  Variable details

Average Open Amount per Order
Type / Numeric
Qualification / Measure
Formula / =[Orders].[Open order stat curr]/[Open order quantity]
Tables / Block 2
Charts
Standalone cells
Alerters
Variables
Max Net Value stat curr
Type / Numeric
Qualification / Measure
Formula / =Max([Net Value stat curr] ) In Block
Tables
Charts
Standalone cells
Alerters / Highest Lowest Net Value
Variables
Min Net Value stat curr
Type / Numeric
Qualification / Measure
Formula / =Min( [Net Value stat curr]) In Block
Tables
Charts
Standalone cells
Alerters / Highest Lowest Net Value
Variables
Total Costs
Type / Numeric
Qualification / Measure
Formula / =[Costs].[Product Costs]+[Costs].[Transport Costs]
Tables / Total Costs
Charts / Total costs Chart
Standalone cells
Alerters
Variables

5  Reports

5.1  Structure

Costs
Header / Header
Header Cell Costs / StandaloneCell
Body / Body
Total Costs / HorizontalTable
Default Table Costs / VerticalTable
Total costs Chart / Pie
Footer / Footer
Orders
Header / Header
Header Cell Orders / StandaloneCell
Body / Body
Default Table Orders / VerticalTable
Block 2 / VerticalTable
Footer / Footer
Product per Region
Header / Header
Header Cell Orders / StandaloneCell
Body / Body
=[Region] / Section
Block 4 / CrossTable
=[Region] / StandaloneCell
=[Product Category] / Section
Block 2 / VerticalTable
=[Product Category] / StandaloneCell
Footer / Footer

5.2  Structure with axes

Costs
Header / Header
Header Cell Costs / StandaloneCell
Body / Body
Total Costs / HorizontalTable
Row
Sales Organization / Dimension
Total Costs / Measure
Default Table Costs / VerticalTable
Column
Sales Organization / Dimension
Sales Organization - Key / Detail
Product Costs / Measure
Transport Costs / Measure
Total costs Chart / Pie
PieSectorColor
Sales Organization / Dimension
PieSectorSize
Total Costs / Measure
Footer / Footer
Orders
Header / Header
Header Cell Orders / StandaloneCell
Body / Body
Default Table Orders / VerticalTable
Column
Sales Organization / Dimension
Sales Organization - Key / Detail
Open order quantity / Measure
Open order quantity Formatted Value / Detail
Open order stat curr / Measure
Open order stat curr Formatted Value / Detail
Block 2 / VerticalTable
Column
Sales Organization / Dimension
Average Open Amount per Order / Measure
Footer / Footer
Product per Region
Header / Header
Header Cell Orders / StandaloneCell
Body / Body
=[Region] / Section
Block 4 / CrossTable
Row
Product Category / Dimension
Column
Plant / Dimension
Body
Net Value stat curr / Measure
=[Region] / StandaloneCell
=[Product Category] / Section
Block 2 / VerticalTable
Column
Product Group / Dimension
Product / Dimension
Net Value stat curr / Measure
Open order stat curr / Measure
=[Product Overview per Region].[Transport Costs]+[Product Overview per Region].[Product Costs] / Formula
=([Product Overview per Region].[Product Costs]+[Product Overview per Region].[Transport Costs])/[Net Value stat curr] / Formula
=[Product Category] / StandaloneCell
Footer / Footer

6  Conditional formats

Simple Alerter
Description / This is a simple Alerter with one rule which contains one condition
Rule 1 / Cell contents LessOrEqual 0.64
Tables / Block 2
Standalone cells
Highest Lowest Net Value
Description / This marks the highest and lowes value of Net Value stst curr. This Alerter uses two rules, each with one condition
Rule 1 / Net Value stat curr Equal Max Net Value stat curr
Rule 2 / Net Value stat curr Equal Min Net Value stat curr
Tables / Block 4
Standalone cells

4