Problem with BIDS

I'm designing an olap db with BIDS (business intelligence developer studio) but I cannot add any calculated members.

When I open the tab for adding calculated measures an error appear (Italian version): Errore imprevisto: 'Errore dell'applicazione'.

Looking in the event viewer I found some errors.

Source: MSOLAP$LocalCube

The description is not very meaningfull: Internal Error

Has anyone experienced this proble before ?

Any idea how to solve it ?

I tried to edit directly the source xml but don't know the sintax.

Cosimo

Have you by any chance installed Office 2007, but are still running SP1? If so this is a known issue, you can either apply SP2 or use the work around on my blog http://geekswithblogs.net/darrengosbell/archive/2006/11/17/97367.aspx

problem with access to analysis services: repository structure cannot be created

Hello,

I have a problem with Analysis Services. We use this product because it's needed for NetIQ Analysis Center, our OLAP reporting tool.

When I try to open the Analysis Manager, I can see the server but when I try to access it, the following error message is displayed: "repository structure cannot be created on the target server: the specified object cannot be found. For more information, see the section 'service pack installation' in the service pack readme file."

I checked this service pack readme file, but couldn't find anything relevant to this problem.
The files for both the sample foodmart and the NetiQ Analysis Center databases are still on this server, so I suppose something happened with the configuration information of this server, not with the databases themselves.

Event entries in the system and application log files do not reveal anything, nothing points to a problem with OLAP/Analysis Services.

The connection string to this server seems to be ok as well.

Unregistering and reregistering this server does not resolve the problem: as soon as I try to register, the same error message is displayed.

SQl, sqlsrvagent, MSDTC and Olap services are all running.

Did anyone see this behaviour before? Or does anyone know how to resolve or how to at least troubleshoot this particular problem?

Help will be much appreciated!

Timur

This sounds like a corruption issue with your repository although possibly it's as simple as a permissions problem with the relational database the repostitory is stored in.

First check your access to the relational database (SQL or Jet) that the repository is stored in. If this is okay, you can restore the default msmdrep.mdb by resetting the repository connection strings. (provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Analysis services\Bin\msmdrep.mdb) Then you can migrate this to SQL if you wish. It is strongly recommended that you use the native format and not the Meta Data Services (previously named Microsoft Repository) format and the latest services packs will even enforce this during migration)

sql

Problem while exporting OLAP data to Excel

Hello all,

I have Analysis Services installed on one machine (dedicated server) .
Other machnines have OLAP application installed (Pivot Table is used).

When client machine tries to export olap data to excel , it takes a long time to load and sometimes it hangs.
Is it related to analysis server settings?

Regards,
Deepti

Deepti, can your provide some more information?

What version of Excel are you using? What version of Analysis Services? Are you trying to export an Office Web Component Pivot connected to Olap data to Excel? If so, what version is the Office Web Component Pivot?