The Budget and Project Status cubes both populate data based on information from the DataWarehouse. To properly configure the new cubes, the data source should be changed to be "Data Source=wp-edw-ssas01.msmyid.uga.edu\dwas".
This article shows how to enter the correct information within Excel.
In this article, you will learn the steps to configure the connection settings for the Budget and Project Status Cubes in Microsoft Excel.
First, log into Office of Institutional Research
From the Office of Institutional Research Operational Reports page (https://oir.uga.edu/data/oper/),
Click the Budget Status Cube link.
Follow the system prompts to open the cube.
To begin using the cube, click the Enable Editing button.
Click the Data tab at the top of the Excel menu ribbon.
To activate the cube, click any cell within the PivotTable.
Note : You will know you have selected the cube when the Analyze and Design tabs are visible in the menu ribbon.
In the Connections section of the Data tab, click the Properties button
The Connection Properties popup window is displayed.
Click the Definition tab.
The Definition tab is displayed. Locate the Connection string field. This field sets parameters for the source data that populates the cube.
Each phrase of the string is separated by a semi colon [;] .
Locate the phrase: "Data Source=dw-as-qa1.msmyid.uga.edu/dwas".
Select: dw-as-qa1.msmyid.uga.edu/dwas.
The selected text needs to be replaced with the correct information.
Enter wp-edw-ssas01.msmyid.uga.edu\dwas
Note: You can delete the entire Connection string and paste in Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=PS_Financials;Data Source=wp-edw-ssas01.msmyid.uga.edu\dwas;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Update Isolation Level=2
Verify that the Connection string contains the new information Data Source=wp-edw-ssas01.msmyid.uga.edu\dwas
Leave the Connection name: field information as displayed.
Enter appropriate information into the Description: field to provide further clarification.
Example shown here: " Production ".
Once all changes have been made, click the OK button.
A confirmation popup is displayed.
Click the Yes button.
Additional Information:
Alternately the entire Connection String can be deleted and the following pasted (Ctrl+V) in:
Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=PS_Financials;Data Source=wp-edw-ssas01.msmyid.uga.edu\dwas;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Update Isolation Level=2