Using Brio To Access The Data Warehouse
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Using Brio To Access The Data Warehouse as PDF for free.
More details
- Words: 1,494
- Pages: 4
Using Brio to Access the Data Warehouse - Frequently Asked Questions (FAQ) Accessing the Warehouse Q101: I can't remember my data warehouse ID or password. What do I do? Q102: Brio is asking for a connection file (default.oce or other .oce file). What and where is a default.oce? Q103: I don't have Brio (Hyperion Intelligence Explorer). Can I use Microsoft Access against the data warehouse? Q104: What does "Net-Lib protocol driver call to connect two endpoints failed" mean? Q105: Can I set up my VPN connection to login automatically? Q106: I'm told I need Sybase drivers to access the data warehouse. Where do I get them? Q107: Is it possible to log into multiple data warehouse databases at the same time? Data in the Warehouse Q201: Where can I find a list of the tables and fields in the warehouse databases? Q202: I have questions about how to use the data once I log onto the data warehouse. Help! Using Brio (a.ka. Hyperion Intelligence Explorer) Q301: When I drag more than one table into a Brio query, the tables automatically join together with multiple lines. What's going on? Q302: I want to use a file as a source for a limit. How do I import the file to use within my query? Q303: How do I change the name of the column header in my Brio Results? Q304: My Brio query is taking a long time to process. How do I cancel it? Q305: How do I copy my Brio query so I can test changes on the copy without changing the original? Q306: Is it possible to change a Section label in Brio? I want to change the word “Query” to something more descriptive. Q307: How do I use results from one query within another query? Q308: How do I know which join type to use? Simple, Left, Right or Outer? Q309: Where can I find information regarding Brio's Report functionality?
Q101: I can't remember my data warehouse ID or password. What do I do? A101: Your warehouse ID is your ASURITE ID. Your warehouse password is not automatically synchronized with your ASURite password, however. New data warehouse user passwords are intially set to your 9-digit ASU ID. You can then use ASU's Sybase password change website to change the password for Enterprise 1 (ENTERPR1_SS - Data Warehouse) to your ASURITE password. If you can't remember your password, email the Sybase DBA team and ask that your password be re-set. Q102: Brio is asking for a connection file (default.oce or other .oce file). What and where is a default.oce? A102: You receive a default Brio connection file, default.oce, when you attend training. You can also download it here. To modify and customize it for your own use, read these Modify oce file instructions. The .oce file tells your Brio software how to find the Data Warehouse server and databases. It saves your ID and your favorite warehouse databases, as well as all the network settings for the connection. It is recommended that your connection file be named default.oce, to facilitate the sharing of queries. Q103: I don't have Brio (Hyperion Intelligence Explorer). Can I use Microsoft Access against the data warehouse? A103: Yes. Be aware that we provide warehouse support for Brio, but not for Access. There are, however, some individuals who use Access who will try to help if they can. Be sure to read through the WUG handout Setting Up Access 2000 to Query the Warehouse. Q104: What does "Net-Lib protocol driver call to connect two endpoints failed" mean? A104: This error indicates a network/connectivity problem. Most often, it's a VPN problem. Have you tried updating your VPN? (In your windows taskbar that is the icon with the envelope and key; to update it, click on that icon, right click on ‘ASU-VPN’ and select Update Site, then press the ‘Update’ button.) Q105: Can I set up my VPN connection to login automatically? A105: Yes. Most users find this very handy. If you have your own dedicated computer (i.e. it’s not a shared machine) you can set up VPN to login automatically for you, as described at http://www.asu.edu/it/security/faqs/vpn.htm#q. Q106: I'm told I need Sybase drivers to access the data warehouse. Where do I get them? A106: You can download Sybase drivers for free, from http://www.asu.edu/it/licensing/sybase.htm. Q107: Is it possible to log into multiple data warehouse database at the same time? A107: Yes. As long as you have access to the databases, you can modify your Brio .oce file to log into multiple databases at once (in Access you can link to external tables in different databases using a different ODBC connection for each database), and use tables from different databases in one query. Q201: Where can I find a list of the tables and fields in the warehouse databases? A201: The Entity Relationship (E/R) diagrams can be found at http://asu.edu/data_admin/data_warehouse-Data%20Diagrams.html. Q202: I have questions about how to use the data once I log onto the data warehouse. Help! A202: There are several options. Attend one or more training classes (see section 5 of How to get Access and Training). Try asking around your department; there are many warehouse-savvy users across ASU's campuses who may be a great resource. Peruse WUG Meeting Handouts
describing techniques for querying the data warehouse. Read through the Data Warehouse wiki; it's a forum for ASU data warehouse users to share tips and tricks. Q301: When I drag more than one table into a Brio query, the tables automatically join together with multiple lines. What's going on? A301: This is Brio's 'Auto join' setting, where Brio automatically joins columns with the same name. This does not work well with our databases; we have same-named columns in many tables that you do not want to join on (e.g. Extract Datetime). To turn off this setting: While in Query mode, select DataModel and then Data Model Options. On the General tab, uncheck the 'Auto join tables' checkbox. This is a preference that is saved with your query, so you need to turn off the setting in all your saved queries, or else the setting will turn on again after you use a query with the Auto join feature turned on. Q302: I want to use a file as a source for a limit. How do I import the file to use within my query? A302: Double-click on the field from the Limit line and then select " Advanced” in the bottom righthand corner. Select “Load From File”, navigate to the source text file to select it and then click on “Open”. Click on “Show Values” and then “Select All” to include the values in the limit. Click on “OK” to close the limit box. Q303: How do I change the name of the column header in my Brio Results? A303: Right click on the field from your Request line on the Query section. Select “Properties…” to open the Item Properties dialog box. Change the field box labeled “Name:” to change the column heading. Q304: My Brio query is taking a long time to process. How do I cancel it? A304: To cancel a query that has been submitted, click “Alt” & “End” keys simultaneously. Q305: How do I copy my Brio query so I can test changes on the copy without changing the original? A305: To create a duplicate query, right click on the query and select “Duplicate Section.” Q306: Is it possible to change a Section label in Brio? I want to change the word “Query” to something more descriptive. A306: To change the label associated with a section, double click on the “Query” from your section listing. In the “Section Label” dialog box, enter your preferred label. Q307: How do I use results from one query within another query? A307: After processing the first query, from the menu select "Insert \ New Query". In the lower left panel, right click on "Tables" and select "Local Results". A new item for "Local Results" will display under the"Tables" item. Click on Local Results. You can then join the Results from your first query (or any other query in this set of queries) to other tables. Q308: How do I know which join type to use? Simple, Left, Right or Outer? A308: Use a simple join when you need records where both tables in the join contain the same value for the joined column. For instance, using a simple join on Affiliate ID from Student to Student_Degree will return only students with a matching record on Student_Degree. Use a Left or Right join when you want the record from one table even if there is no matching record in another table (e.g. a Left join from Student to Student_Degree will return the student information even if there is no data in Student_Degree for that student). Q309: Where can I find information regarding Brio's Report functionality? A309: The Brio 6 Report primer can be found at: http://asu.edu/data_admin/WUG/Brio_Report_Primer.pdf.
Still have questions? Email [email protected].
Q101: I can't remember my data warehouse ID or password. What do I do? A101: Your warehouse ID is your ASURITE ID. Your warehouse password is not automatically synchronized with your ASURite password, however. New data warehouse user passwords are intially set to your 9-digit ASU ID. You can then use ASU's Sybase password change website to change the password for Enterprise 1 (ENTERPR1_SS - Data Warehouse) to your ASURITE password. If you can't remember your password, email the Sybase DBA team and ask that your password be re-set. Q102: Brio is asking for a connection file (default.oce or other .oce file). What and where is a default.oce? A102: You receive a default Brio connection file, default.oce, when you attend training. You can also download it here. To modify and customize it for your own use, read these Modify oce file instructions. The .oce file tells your Brio software how to find the Data Warehouse server and databases. It saves your ID and your favorite warehouse databases, as well as all the network settings for the connection. It is recommended that your connection file be named default.oce, to facilitate the sharing of queries. Q103: I don't have Brio (Hyperion Intelligence Explorer). Can I use Microsoft Access against the data warehouse? A103: Yes. Be aware that we provide warehouse support for Brio, but not for Access. There are, however, some individuals who use Access who will try to help if they can. Be sure to read through the WUG handout Setting Up Access 2000 to Query the Warehouse. Q104: What does "Net-Lib protocol driver call to connect two endpoints failed" mean? A104: This error indicates a network/connectivity problem. Most often, it's a VPN problem. Have you tried updating your VPN? (In your windows taskbar that is the icon with the envelope and key; to update it, click on that icon, right click on ‘ASU-VPN’ and select Update Site, then press the ‘Update’ button.) Q105: Can I set up my VPN connection to login automatically? A105: Yes. Most users find this very handy. If you have your own dedicated computer (i.e. it’s not a shared machine) you can set up VPN to login automatically for you, as described at http://www.asu.edu/it/security/faqs/vpn.htm#q. Q106: I'm told I need Sybase drivers to access the data warehouse. Where do I get them? A106: You can download Sybase drivers for free, from http://www.asu.edu/it/licensing/sybase.htm. Q107: Is it possible to log into multiple data warehouse database at the same time? A107: Yes. As long as you have access to the databases, you can modify your Brio .oce file to log into multiple databases at once (in Access you can link to external tables in different databases using a different ODBC connection for each database), and use tables from different databases in one query. Q201: Where can I find a list of the tables and fields in the warehouse databases? A201: The Entity Relationship (E/R) diagrams can be found at http://asu.edu/data_admin/data_warehouse-Data%20Diagrams.html. Q202: I have questions about how to use the data once I log onto the data warehouse. Help! A202: There are several options. Attend one or more training classes (see section 5 of How to get Access and Training). Try asking around your department; there are many warehouse-savvy users across ASU's campuses who may be a great resource. Peruse WUG Meeting Handouts
describing techniques for querying the data warehouse. Read through the Data Warehouse wiki; it's a forum for ASU data warehouse users to share tips and tricks. Q301: When I drag more than one table into a Brio query, the tables automatically join together with multiple lines. What's going on? A301: This is Brio's 'Auto join' setting, where Brio automatically joins columns with the same name. This does not work well with our databases; we have same-named columns in many tables that you do not want to join on (e.g. Extract Datetime). To turn off this setting: While in Query mode, select DataModel and then Data Model Options. On the General tab, uncheck the 'Auto join tables' checkbox. This is a preference that is saved with your query, so you need to turn off the setting in all your saved queries, or else the setting will turn on again after you use a query with the Auto join feature turned on. Q302: I want to use a file as a source for a limit. How do I import the file to use within my query? A302: Double-click on the field from the Limit line and then select " Advanced” in the bottom righthand corner. Select “Load From File”, navigate to the source text file to select it and then click on “Open”. Click on “Show Values” and then “Select All” to include the values in the limit. Click on “OK” to close the limit box. Q303: How do I change the name of the column header in my Brio Results? A303: Right click on the field from your Request line on the Query section. Select “Properties…” to open the Item Properties dialog box. Change the field box labeled “Name:” to change the column heading. Q304: My Brio query is taking a long time to process. How do I cancel it? A304: To cancel a query that has been submitted, click “Alt” & “End” keys simultaneously. Q305: How do I copy my Brio query so I can test changes on the copy without changing the original? A305: To create a duplicate query, right click on the query and select “Duplicate Section.” Q306: Is it possible to change a Section label in Brio? I want to change the word “Query” to something more descriptive. A306: To change the label associated with a section, double click on the “Query” from your section listing. In the “Section Label” dialog box, enter your preferred label. Q307: How do I use results from one query within another query? A307: After processing the first query, from the menu select "Insert \ New Query". In the lower left panel, right click on "Tables" and select "Local Results". A new item for "Local Results" will display under the"Tables" item. Click on Local Results. You can then join the Results from your first query (or any other query in this set of queries) to other tables. Q308: How do I know which join type to use? Simple, Left, Right or Outer? A308: Use a simple join when you need records where both tables in the join contain the same value for the joined column. For instance, using a simple join on Affiliate ID from Student to Student_Degree will return only students with a matching record on Student_Degree. Use a Left or Right join when you want the record from one table even if there is no matching record in another table (e.g. a Left join from Student to Student_Degree will return the student information even if there is no data in Student_Degree for that student). Q309: Where can I find information regarding Brio's Report functionality? A309: The Brio 6 Report primer can be found at: http://asu.edu/data_admin/WUG/Brio_Report_Primer.pdf.
Still have questions? Email [email protected].
Related Documents
Using Brio To Access The Data Warehouse
November 2019 11
Analyzing Data Using Access
May 2020 8
Data Warehouse
November 2019 23
Data Warehouse
November 2019 18
Data Warehouse
October 2019 19