Activity Hub FAQs
- Saparnell
- 1 AH Specific FAQs
- 2 Access
- 2.1 Q: Can I have direct SQL Access to the Activity Hubs?
- 2.2 Q: I work in IT, can I have direct SQL Access to the Activity Hubs?
- 2.3 Q: I’m a consultant on a high priority project, can I have direct SQL Access to the Activity Hubs?
- 2.4 Q: I just need to build some quick queries for a project, can I have direct SQL Access to the Activity Hubs?
- 3 Lived and Legal Names
- 4 Snapshots
AH Specific FAQs
Cognos FAQs = https://blink.ucsd.edu/technology/bi/tools/cognos/index.html#FAQs
Tableau FAQs = https://blink.ucsd.edu/technology/bi/tools/tableau/index.html#FAQS
Access
Q: Can I have direct SQL Access to the Activity Hubs?
A: All Activity Hub users can access Activity Hub data via Cognos, Tableau or data integration for their reporting and data integration needs.
See Data Connection Policies for more information.
See Getting Data Out of an Activity Hub for more information.
Q: I work in IT, can I have direct SQL Access to the Activity Hubs?
A: All Activity Hub users can access Activity Hub data via Cognos, Tableau or data integration for their reporting and data integration needs.
See Data Connection Policies for more information.
See Getting Data Out of an Activity Hub for more information.
Q: I’m a consultant on a high priority project, can I have direct SQL Access to the Activity Hubs?
A: All Activity Hub users can access Activity Hub data via Cognos, Tableau or data integration for their reporting and data integration needs.
See Data Connection Policies for more information.
See Getting Data Out of an Activity Hub for more information.
Q: I just need to build some quick queries for a project, can I have direct SQL Access to the Activity Hubs?
A: All Activity Hub users can access Activity Hub data via Cognos, Tableau or data integration for their reporting and data integration needs.
See Data Connection Policies for more information.
See Getting Data Out of an Activity Hub for more information.
Lived and Legal Names
Q: Are lived names or legal names in the Activity Hubs?
A: All fields indicating Employee Name, Person Name, Student Name or related Name fields will always show the lived name (when available) and only display the legal name when the lived name is not available. Access to legal name will be decided by the specific data steward on a case-by-case basis.
Snapshots
Q: What is a snapshot?
A: A data snapshot is a copy of the data at a specific moment in time. Snapshots can be used to back up and restore data, or lock numbers in place.
Q: How do I replicate my old snapshots?
A: Activity Hub Views can be built with specific dates that allow you to create snapshots of any day of your choosing. This has already been done in a number of EAH views: How To Do Snapshot Reporting with AsOf Fields. SAH has Census views that make snapshots of Census dates available to users.