Set up in Internet Explorer
Open
Internet Explorer (it has to be
Internet Explorer), and go to the
URL: https://olap.keepers.nu/msmdpump.dll
A log in box will open up. Press "More
options" and "Use a different account".
Fill in the information you have gotten per
e-mail from Keepers. Remember to use
"BIPROD\" before your
username.
Press
OK. You will get an error, but this
is as it should
be.
Close
Internet Explorer.
Set up in Microsoft Excel
Open Microsoft Excel. Choose "Data",
"Get Data", "From Database"
and "From Analysis service"
Add
the server: https://olap.keepers.nu/msmdpump.dll and
for "Log on credentials" choose "Use Windows
Authentication"
Choose
the Cube that is stated in the
e-mail you received from Keepers, and
press "Next".
Type in the "Friendly name"
that is used for the cube in your
organization.
Press
"Finish"
You now have the option to choose, how you want your data to be displayed. You can choose between a Pivot table, a Pivot chart or just to make the connection. If you choose to just make the connection, you need to make the formulas yourself, to get the data you need.
