Oracle Mobile App Designer simple report
Today I'll show how to create a very simple Oracle Business Intelligence Mobile App Designer (BIMAD) report. For this demonstration, I use the sample repository shipped with OBIEE.
Login to OBIEE as usual. Navigate to Home page and select Mobile app in Create section.
The first decision you need to make is the type of your application (report). You can create either Phone or Tablet application. For my demo I choose Phone and press Next button.
Next step is selecting the data source for you report. For this demo, I choose the easiest way and select BI Subject Area option. I use Sample Sales Lite subject area. Using BI Subject Area isn't the best option or something like that. It's just the simplest choice. Other options are normal as well, but they involve more steps than this one. Pres Save button to proceed.
You need to save your report before starting to work with it. It's important to save the report outside of the BIMAD publishing directory (see this post about BIMAD installation for information about publishing directory).
After saving the report, you get a blank report that have only one page with Oracle's yacht as a cover page picture.
You can change the title, subtitle and background picture.
Start building your application by adding a page to it. I added a blank page.
I think you want to change the name of this page, but I won't change it. You may do it by double clicking the page.
Let's add a chart to this blank page. The button for adding components is not very well-marked. It's a small square button with plus sign on it on top of working area.
Template for a chart added to a page. In the beginning, it's just a placeholder and shows no information.
Drag and drop Revenue measure (or other measure you like) to the box with Drop Value Here label. Now this chart shows total revenue.
Drag and drop Per Name Year attribute to Drop Label Hire box and LOB to Drop series Here one.
It's very easy to change a style of the chart. Keep the chart selected and in the panel on the right, select chart type icon. I changed type to Vertical Stacked Bar.
I like the way the chart look like now.
Add one more component to this page.
This time we add a more complex component - Accordion.
Define accordion's properties as shown in the screenshot. I want accordion to be grouped by LOB's and show distinct count of orders for each LOB.
Keep accordion selected (orange frame around it) and add one more component - a table. Note: if accordion is not selected, table will be added not as I child of it but as a sibling. In that case delete a table, select accordion and try again.
If everything is right, you'll see a table inside of the accordion.
Drag and drop Product Type and Billed Quantity to the table. When dragging the second field use a vertical blue line as a sign where new field is going to be added.
When done use Preview button to see how your report will look like on a mobile device.
Not good. Font is too big. And Billed Quantity total has a decimal part it shouldn't have.
Go back to editing the report and select Billed Quantity label. It should be surrounded by an orange frame. Change font size to 10pt. Repeat this for over parts of the table.
When edit Billed Quantity chenge not only the font but Decimals to 0 also.
Now it's time to publish our report to the app store. It's not Apple App Store, of course, but our own. Press Publish button.
Select Locallibrary and press Next.
The next step is to choose an icon for the application. Users will see this icon in their library so choose it wisely. Press the button with different icons on it to choose yours.
Choose any icon on your local disk and it will be uploaded to the server.
If everything is ok, you press Publish button on the last step and ...drums!
Your app is published successfully! Click View button to see it in the library.
By default, tablet apps are shown. Click Phone Apps to see your newly published app. Now users can see your app and add it to their libraries.
Take your favorite smartphone (not necessarily iPhone), run your favorite web browser and navigate to //yourbihost:9704/mobile/appstore. Add this address to the favorites.
Input your login and password.
And you see your apps library. Right now it's empty, but not for long. Press Library button to see all applications available for you.
Select Phone apps and here it is - our first BIMAD application. Select it.
You need to subscribe on an application to start use it. Press Subscribe button.
Now you can see this application in your library. Select it and ...here it is.
And our pages.
And our chart and accordion.
Now you know
Kung Fu how to build BIMAD applications.
Don't hesitate to leave a comment or two.
OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.