|
Home > Archive > MS SQL Server OLAP > December 2005 > Analysis Server and BSM 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Analysis Server and BSM 2005
|
|
| Gonzalo 2005-12-21, 8:25 pm |
| Hi,
I built a Scorecard using BSM 2005 connected to an OLAP Cube. Using the
scorecard reports, I created a Pivot Chart with data from the cube. Doing
this, i created a .odc connection that is stored on My data sources folder.
The problem I have is that this report is only available for browsing from my
computer, and not from others. How can I configure a connection to the OLAP
Server that is available for all users connected from other computers, like a
System DSN, but for OLAP.
| |
| Darren Gosbell 2005-12-23, 8:24 pm |
| I believe PivotTables and PivotCharts store the datasource details
internally and will not reference the .odc file once they have been
created. Do you know if you users are set up in OLAP roles that have
privileges to see the cubes?
You could test by trying to setup a Pivot Table in Excel.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <EDF9673E-32AE-4157-A405- B55B620F0B1E@microso
ft.com>,
Gonzalo@discussions.microsoft.com says...
> Hi,
>
> I built a Scorecard using BSM 2005 connected to an OLAP Cube. Using the
> scorecard reports, I created a Pivot Chart with data from the cube. Doing
> this, i created a .odc connection that is stored on My data sources folder.
> The problem I have is that this report is only available for browsing from my
> computer, and not from others. How can I configure a connection to the OLAP
> Server that is available for all users connected from other computers, like a
> System DSN, but for OLAP.
>
|
|
|
|
|