No data found when I browse cube

Hi,I have MS SQL Server (& Analysis Server) installed on a Windows 2000 server machine.I installed the MS SQL Server client and Analysis server on my local machine too(Windows NT).Now,I created an Analysis database on my local machine whose data source lies on the Windows 2000 server machine.When I access the cube data from my local m/c,I can see the data.
Then,I took the backup of my local Analysis database(.CAB) and restored it onto the Windows 2000 server machine.But now,when I try to browse the cube data on the Windows 2000 server machine,I don't find any data!!
I don't have to clue about what went wrong.I have installed SP3 on both the machinessql

No connection could be made because the target machine actively refused it

Hi,

I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown.

No connection could be made because the target machine actively refused it

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SocketException (0x274d): No connection could be made because the target machine actively refused it]

System.Net.Sockets.Socket.Connect(EndPoint remoteEP) +307

System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) +24

System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port) +81

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +208

[AdomdConnectionException: A connection cannot be made. Ensure that the server is running.]

Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) +384

Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) +51

Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) +398

Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla() +124

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) +144

Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() +601

cubicdimension.Reportdisp.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\cubicdimension\Reportdisp.aspx.vb:65

System.Web.UI.Control.OnLoad(EventArgs e) +67

System.Web.UI.Control.LoadRecursive() +35

System.Web.UI.Page.ProcessRequestMain() +731

May I mention here, that the computer where I tried deploying, has SQL Server 2000 as well as SQL Server 2005. I tried reinstalling MSXML, but the computer already has a higher version of MSXML.

Any help in this regard would be appreciated.

Best Wishes.

Check Programs/SQL Server 2005/ Configuration tools/SQL Server Surface Area Configuration.

In "Surface Area Configuration for services and connection", you click on the service and remote connections.

See that you have local and remote connections activated.

HTH

Thomas Ivarsson

No aggregations for Measure Group possible in Analysis Server 2005

I have a cube with about 20 Measure Groups and 30 dimensions. I built some dimensions using BI Development Studio a few weeks ago. The aggregations were build for any measure group without problems.

Now I changed some attributes and want to run the aggregation wizard on my test plattform to design new aggregations. But there were no aggregations build. It shows 0 aggregations.

I read that sometimes this happens when the cube is too complex. But the complexity did not grow very much.

What should I do to be able to design aggregations again?

Best regards,
Stefoon

There is an exellent writeup about aggregations in performance guide.

Chirs's blog is good source for information http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry

Edward.

--

This posting is provided "AS IS" with no warranties, and confers no rights.

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.