1 Basics

What can I do with Oracle Analytics Day by Day?

Oracle Analytics Day by Day is an innovative app that provides the right analytics at the right time and place.

Based on your searches for business data in the app, it learns what you’re interested in, when and where you’re interested in it, and it displays the data in ready-to-use analytical charts. The app displays the analytical charts as cards.

With Oracle Analytics Day by Day, you can:

  • Search for business data in your Oracle Analytics Cloud instance.


    Search in the app searches for data but doesn't search for existing content such as titles of projects or reports.
  • Add the search results to the app's recommended list as analytic cards, if you're an administrator; otherwise add the search results to your feed.

  • Access the analytical cards when and where you want them without searching for them repeatedly.

  • Perform voice queries to generate the analytical cards.

  • Invite colleagues from the contacts list on your mobile device to use the app.

  • View insights about the cards.

  • Share with nearby users across the iOS and Android operating systems.

  • Share and collaborate on the analytical cards privately with individual users or groups of users. Users can be either:
    • Suggested users; who are in the contacts list on your mobile device and are also registered users of the app with an email address that exactly matches the email of the user ID that they use for the app.

    • Users; who are available in your Oracle Analytics Cloud instance and are also registered users of the app.

  • Add comments that are visible to all on the analytical cards.

Are there any prerequisites for this app?

Yes, you must have access to Oracle Analytics Cloud with BI Author and DV Consumer roles.

What is the Recommended feed?

Recommended feed displays the cards that your organization wants everyone to view.

It also displays the popular searches and the cards that have been shared with you by others.

What is your feed?

Your feed is a series of analytical cards that are meaningful to you based on what's going on with your business in a week, month, or since the time you started using the app.

What is a crew?

A crew is a group of users that you most often communicate with regarding your business.

What data does the app use?

The app uses data that is available in your Oracle Analytics Cloud instance based on the subject areas and data sets that are indexed. See Configuring Search Indexing and Index File-Based Data Sets.

Can I add comments to the cards and who can see them?

Yes, you can add public and private comments. These are visible to:

  • Users who share your server and security settings, and search for the same data as you, can see public comments that you add. These users see the same card and any comments that you added to the card. For example, if you and other users search for Revenue and Product, then the app displays the same card and public comments to you and those users.

  • Specific users or crews (groups of users) with whom you share a card can see private comments that you add. For example, if you share a card with specific users or your crew, then the app adds that card to the For You feed of those users. They can view your comments and add their own comments.

How do I configure mobile applications for single sign-on in Oracle Analytics Cloud?

You must set up OAuth in Oracle Identity Cloud Service for mobile access.

  1. Log in to Oracle Identity Cloud Service using your administrator credentials.


    If you don't have access to Oracle Identity Cloud Service, then ask your administrator to set up OAuth.
  2. In the Oracle Identity Cloud Service console, expand the Navigation menu, and then click Applications.
  3. On the Applications page, click Add.
  4. In the Add Application dialog, click Mobile Application.
  5. In the Details section, enter a name and description to identify the application, and then click Next.
    For example:
    • Name: MyMobileApp
    • Description: Mobile application for Oracle Analytics
    Description of configure-mobile-apps-sso-oac-4.gif follows
    Description of the illustration configure-mobile-apps-sso-oac-4.gif
  6. To identify this application as a client:
    1. Display the Authorization section in the Client step.
    2. Select Authorization Code and Allow non-HTTPS URLs.
    3. Enter these values exactly as specified:
      • Redirect URL: idcsmobileapp://nodata

        This URL scheme identifies the application to open.

      • Post Logout Redirect URL: idcsmobileapp://logout
    Description of configure-mobile-apps-sso-oac-5.gif follows
    Description of the illustration configure-mobile-apps-sso-oac-5.gif


    Ensure that you don't populate the Logout URL field.
  7. In the Client step, scroll down and select Add Scope and the Oracle Analytics Cloud instance that you want to access through this application.
    You see an URL in the Resources section.
  8. In the Resources section, scroll to the end of the URL and note the entire URL.
  9. In the Client step, scroll to the bottom of the page and click Add below Grant the client access to Identity Cloud Service Admin APIs.
  10. In the Add App Role dialog, select the application roles that you want to assign to this application, and then click Add.
  11. In the Client step, click Next until you reach the last step, and then click Finish.
  12. From the Application Added dialog, make a note of the Client ID value, and then click Close.


    The mobile application needs the Client ID value to integrate with Oracle Identity Cloud Service.
  13. From Applications, click the test page of the mobile application you just created; for example, MyMobileAppTest or MobileAppTest, and then click Activate.
  14. In the Activate Application dialog, click Activate Application.

How do I access Oracle Identity Cloud Service using single sign-on from Oracle Analytics Day by Day?

You can access Oracle Identity Cloud Service using single sign-on from Oracle Analytics Day by Day with a MagicURL.

A MagicURL contains all the required information to access Oracle Identity Cloud Service using single sign-on and can be shared across your organization. It contains these five elements:
  • Mobile app code name: daybydayoracle
  • Client ID: Value of the mobile application that you configured for single sign-on in Oracle Analytics Cloud. For example, 123ab456cd.
  • Oracle Analytics Cloud Scope URL: Available in the Resources section of the mobile application that you configured for single sign-on in Oracle Analytics Cloud. For example, https://ABCDFG1234.analytics.oac.com:123urn:opc:resource:consumer:all.
  • Oracle Analytics Cloud URL. For example, https://analytics.myserver.com.
  • Oracle Identity Cloud Service URL. For example, https://123abc456fgh.identity.oraclecloud.com.

The MagicURL with these values would look like: daybydayoracle://oauth?clientID=123ab456cd&friendlyURL=https://analytics.myserver.com&scope=openid%20https%3A%2F%2FABCDFG1234.analytics.oac.com%3A123urn%3Aopc%3Aresource%3Aconsumer%3Aall&idcsURL=https://123abc456fgh.identity.oraclecloud.com


To retrieve the Client ID and the Scope URL, navigate to your Oracle Identity Cloud Service Admin Console, click Applications, click Mobile App, and then click Configuration. You see Client ID in the General Information section and Scope URL in the Client Configuration section by scrolling down until you see Token Insurance Policy.

How do I create and distribute the MagicURL for Oracle Analytics Day by Day manually?

After you complete the federated single sign-on configuration, create the MagicURL based on bits of information taken from the configuration. To create the MagicURL, you must have administrator privileges in Oracle Identity Cloud Service.
  1. Collect the information required for the MagicURL.
  2. Use the following URL format and replace the brackets and their content, for each one of its corresponding elements:
    [Mobile App code name]://oauth?clientID=[Client ID]&friendlyURL=[OAC friendly URL]&scope=openid%20[Scope URL]&idcsURL=[IDCS URL]
  3. Distribute the MagicURL to your user community using email, a corporate messenger, or other appropriate channel.

How do I use the MagicURL for Oracle Analytics Day by Day?

As a user who has installed Oracle Analytics Day by Day and received the MagicURL sent by your organization, tap the MagicURL from your mobile device. The app opens and automatically provisions itself.


You mustn’t use Gmail as your mail client to access the MagicURL; a known issue exists with Gmail where such hyperlinks are treated as plain text.