{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Private Cloud Deployment /
avatar image
0
Question by daniel.biales · Nov 20, 2018 at 05:12 PM · 62 Views analyticscustom reportscustom attributes

Statistics Collection variables not showing up in Custom Reports dimensions

I created a proxy and I wanted to create a custom report based on the username passed into the auth header. I extracted the username and added it to my statistic collector. I passed some data through the proxy in both our test and dev environments but when I went to create a custom report the dimension did not show up in the drop down. I waited well over 30 minutes. Is there something I am doing wrong? Also is there a way to verify that the statistic collector policy is working, through the trace?

Comment
Add comment
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Close

1 Answer

  • Sort: 
avatar image
1
Best Answer

Answer by Dino-at-Google   · Nov 20, 2018 at 06:49 PM

Since you have private cloud, you can directly query the fact tables in Postgres to verify that the data is appearing as you expect. Custom dimensions should appear in those fact tables. You need to run psql to do that.

-- Select most recent facts:
select *
  FROM analytics."org1.env1.fact"
  WHERE client_received_start_timestamp > '2018-11-19 18:00:00'
  ORDER BY client_received_start_timestamp DESC LIMIT 30;

I think you should be able to see the data there . If it's not there, report back....

Comment
Add comment Show 4 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image daniel.biales · Nov 26, 2018 at 07:41 PM 0
Link

So it looks like one of the issues was I had a capital letter in my dimension name. Now the dimension columns are showing up in postgres but the data says [null]

avatar image daniel.biales · Nov 26, 2018 at 07:53 PM 0
Link

Here is my policy

<Statistics>
  <Statistic name="username" ref="request.header.username" type="string">
    n0000000
  </Statistic>
  <Statistic name="path_bucket" ref="resource.bucket" type="string">
    /
  </Statistic>
</Statistics>

I am getting the username from a base64 decode policy and the path_bucket from a javascript context.setVariable()

avatar image daniel.biales · Nov 30, 2018 at 02:45 PM 0
Link

@Dino-at-Google any updates?

avatar image daniel.biales · Dec 03, 2018 at 10:16 PM 0
Link

It looks like it is working now. It must have taken more than 30 minutes for it to start recording data

Follow this Question

Answers Answers and Comments

62 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Error while fetching object while opening API Proxies page 1 Answer

How do you convert to Active/Active analytics on a 4.16.x existing installation? 1 Answer

getting broken pipe error in system.log 1 Answer

How to fix dropdb error during restore-postgres ? 1 Answer

What is the easiest way to disable analytics? 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2019 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Members
  • Badges