Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BICS Usage Tracking

Received Response
51
Views
4
Comments
Sarika Chaudhari-90951
Sarika Chaudhari-90951 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BICS Usage Tracking

Content

Hi,

I am trying to implement Usage tracking in BICS. But unable to get result in respective usage tracking table.

I have followed below steps while implementing usage tracking:

1. Created CLOUD_UT_V1 and CLOUD_UT_VIEW

imageimage

2. Created UT_Entry database function :

image

3. Created two tables which will track dashboard and user visits:

imageimage

4. Created logical joins between the tables and also created column which will insert tracking info into tables :

image

5. Created trigger report and added to dashboard.

But after implementing all steps, tables does not show any data into it.

Can you please guide me if anything i have missed here.

Thanks,

Sarika

Answers

  • Hasso Schaap
    Hasso Schaap Rank 4 - Community Specialist

    Hi ​,

    Have you tried the function if it works with a select statement in APEX SQL Workshop?

    Like:

    SELECT UT_ENTRY (1, 'Test user', 'Test Dashboard', 'Test Dashboard Page',  null) FROM DUAL;

    Could you also show what your report looks like in the Criteria and expression editors?

    And could you show the query from the session log?

    That could be of help in troubleshooting...

  • Hasso Schaap
    Hasso Schaap Rank 4 - Community Specialist

    OK,

    But could you show that after running the select UT_ENTRY(...) form dual also inserts into the table.

    So prove it with:

    select * from CLOUD_UT_V1

    to see that actually the record WAS inserted...

    Are you sure you need to join those tables? It looks like that after the join no records are left in the result....

    And are you selecting from the RIGHT tables that are the same as the one that actually got the record inserted -> Compare CLOUD_UT_USERS & CLOUD_UT_DASHBOARDS versus CLOUD_UT_V1

    You function inserts into CLOUD_UT_V1

    Your reporting query actually looks in different tables:

    You said: "3. Created two tables which will track dashboard and user visits"

    But that is not the table you are inserting, right?

    Fix that first.

    Or when CLOUD_UT_V1 has no data, fix the function first.

    Regards

  • Sarika Chaudhari-90951
    Sarika Chaudhari-90951 Rank 2 - Community Beginner

    1. SELECT UT_ENTRY (1, 'Test user', 'Test Dashboard', 'Test Dashboard Page',  null) FROM DUAL;

    -> This query returns 1

    2. Could you also show what your report looks like in the Criteria and expression editors?

    -> Usage Tracking Report:

    image

    Expression:

    image

    Added Usage Tracking Report in one of dashboard:

    image

    3. Session Query returns no data :

    image

    Please let me know, if you need anything

    Thanks,

    Sarika

  • Jeanette Busby
    Jeanette Busby Rank 1 - Community Starter

    Hi,  I had the same problem - though my issue was data related.  Make sure that in the user table - the value is the "DISPLAY" name.  I implemented and tested with login name and did not get anything.  For example john.smith@abc.con -  when the row I inserted should have had -->  John Smith

    As soon as I changed that my testing succeeded.

    Jeannie