Mobile App and Essbase

Here is a tease of a session I encourage you to join on COLLABORATE 15, as I help with the prep work a bit 😀

Collaborate

I will post some tricks you might need to this on your own, if you want to try it out, after the session tho 😀

As promised the lessons learned:
I) Essbase Application on which we are reporting should be rolling up possibly to top (Gen1).
II) Name Generations in Essbase – for less confusion
Essbase_Named_Gen
III) Don’t flatten account dimension – keep “Fact” – and change setting on Account dimension
Accounts
IV) Tag one dimension as a time dimension
Period
V) (“the other option”): Can be done trough Data Model (BI Publisher) created from SQL statement from reports created in Analysis (copied from under “Advanced” tab), example of SQL statement (which you can already adjust):
GetSQL

SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12 FROM (
SELECT
0 s_0,
"PRS"."Account"."Accounts" s_1,
"PRS"."Department"."G2: AllDepts and Settings" s_2,
"PRS"."Department"."G3: Department" s_3,
"PRS"."Product"."G2: AllProd and NoProd" s_4,
"PRS"."Product"."G3: Product" s_5,
SORTKEY("PRS"."Account"."Accounts") s_6,
SORTKEY("PRS"."Department"."G2: AllDepts and Settings") s_7,
SORTKEY("PRS"."Department"."G3: Department") s_8,
SORTKEY("PRS"."Product"."G2: AllProd and NoProd") s_9,
SORTKEY("PRS"."Product"."G3: Product") s_10,
"PRS"."IncStmt"."Fact" s_11,
REPORT_AGGREGATE("PRS"."IncStmt"."Fact" BY "PRS"."Department"."G2: AllDepts and Settings","PRS"."Department"."G3: Department","PRS"."Product"."G2: AllProd and NoProd","PRS"."Account"."Accounts") s_12
FROM "PRS"
WHERE
(("Year"."Year - Default" = 'FY16') AND ("Scenario"."Scenario - Default" = 'Budget') AND ("Version"."Version - Default" = 'Working Version') AND ("Period"."G2: Total Year and BegBalance" = 'YearTotal') AND ("Product"."G2: AllProd and NoProd" <> 'NoProd') AND ("Department"."G2: AllDepts and Settings" <> 'Settings') AND ("Account"."Accounts" IN ('Price', 'Volume', 'Revenue', 'COGS', 'Discount', 'Bonus', 'SalesExp', '')))
) djm ORDER BY 1, 10 ASC NULLS LAST, 8 ASC NULLS LAST, 9 ASC NULLS LAST, 7 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

A) Working with Data Model
Creating a Data Set
Create_Data_Model

In the Data tab:
I) Click View
II) Click “Table View”
III)(Optional) Either in SQL or in tab Structure change the column names to make it easier to identify in Mobile designer
Create_Data_Model02

Ready to save and use

Normal by using Subject Areas
Create_Mobile_BISA

Using Bi Publisher Data Model
Create_Mobile_BIPublisher

And this is how it looks like at end:
Mobile

Leave a Reply

Your email address will not be published. Required fields are marked *