BICS Usage Tracking

Sarika Chaudhari-90951

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

2. Created UT_Entry database function :

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

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

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

Hasso Schaap

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

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

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:

Expression:

Added Usage Tracking Report in one of dashboard:

3. Session Query returns no data :

Please let me know, if you need anything

Thanks,

Sarika

Jeanette Busby

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