2.8 Build workspaces in F&O

Question 1

What are workspaces?

Answer 1

Personalized work centers with data, reports, and transactions
Designed to increase efficiency of all daily tasks

Question 2

Why create and design workspace in developer env. instead of UI?

Answer 2

Business might want KPI tiles, analytical components, drillthrough components, and other advanced features that cannot be created in UI

Question 3

KPI?

Answer 3

Key Performance Indicator

Question 4

What should KPI have?

Answer 4

Clear objectives that are periodically reviewed to ensure that the objectives are being met

Question 5

How to create KPI?

Answer 5

Using aggregate data contained in aggregate measurements, which is a model that contains a collection of measures and their corresponding dimensions

Question 6

What can aggregate measurements measure?

Answer 6

Sum
Minimum
Maximum
Count
Distinct count
Average

Question 7

By default what measure does “Default aggregate” use?

Answer 7

Count measure

Question 8

Two ways to deploy aggregate measurement using Usage property?

Answer 8

InMemoryRealTime
StagedEntityStore

Question 9

InMemoryRealTime?

Answer 9

Uses column store indexes of the SQL Server DB to get real time data

Question 10

StagedEntityStore?

Answer 10

Entity store that uses near real-time Power BI reporting
Data gets refreshed periodically

Question 11

Why use Drill-Through elements?

Answer 11

Helps view additional data within the page

Question 12

Example of Drill-Through?

Answer 12

View on workspace exists to see the total number of sales, by selecting the link in data you can access more detailed view of each sale

Question 13

What are tiles?

Answer 13

Buttons added to a workspace that allow the user to view data
Tiles can display a record count of data and they can also provide drill-through access

Question 14

RDL?

Answer 14

Report Definition Language

Question 15

Report Definition Language?

Answer 15

XML representation of an SSRS report definition

Question 16

What does report definition contain?

Answer 16

Data retrieval and layout information for a report
Allows custom functions for controlling report item values, styles, and formatting by accessing code assemblies within report definition files

Question 17

Why use RDL?

Answer 17

Define charts, graphs, calculations, text, images, and other report objects

Question 18

High-level steps of creating KPI in Dev Env?

Answer 18

1. Create the KPI object
2. Define KPI range, goals, and/or trends
3. Create a tile for the KPI to display on
4. Add the KPI to the tile