Entities disappear from Report Builder Explorer when datasource is a cube

I have scoured the internet looking for someone who has run into this issue with no such luck!

Product: Reporting Services 2005
Analysis Services 2005

Our users use Report Builder as an ad-hoc report tool. Data sources for Report Builder come from Report Servers and Analysis Servers.

I have run into issues where a user will select a source for their report that is based on an AS cube. When they select an attribute (field) from a selected entity in the Report Builder Explorer and drop it on the canvas, all entities except the one the field was selected from disappear.

For example:

A cube has a fact table called "Annual Income" with dimension of employee and demographics. In Report Builder, the entities would be listed in the left hand Report Builder Explorer window as

Annual Income
Employee
Demographics

If I select attributes from Employee or Annual Income, as usual, you will see the related hierarchies of the remaining entities. However, if I select an attribute from Demographics, then the Annual Income and Employee entities just disappear and all I can see is the Demographics entity and its attributes.

Has anyone run into this and if so, any ideas? This is becoming extremely frustrating. I have deleted and rebuild cubes, individual dimensions, and everything else I can think of.

Your responses are appreciated,
Scott

Anyone?sql

Enterprise Manager appears to slow my dial up connection

I am using a dial up connection to the Internet and to an online SQL
Server database.

I have a problem in that when I use Enterprise Manager to access even
my local server , or even, it appears, when it is just open with no
connection to any SQL Server, I experience very slow data transfer
over my normal dial up connection.

I am reasonably sure it is Enterprise Manager causing the problem as
when I close it and redial I have an acceptable rate of data transfer
using my dial up connection.

Can anyone:

a. support my conclusion that Enterprise Manager is the probable
cause of the slow connection.

b. suggest a solution

Best wishes, John MorganJohn Morgan (jfm@.XXwoodlander.co.uk) writes:
> I am using a dial up connection to the Internet and to an online SQL
> Server database.
> I have a problem in that when I use Enterprise Manager to access even
> my local server , or even, it appears, when it is just open with no
> connection to any SQL Server, I experience very slow data transfer
> over my normal dial up connection.
> I am reasonably sure it is Enterprise Manager causing the problem as
> when I close it and redial I have an acceptable rate of data transfer
> using my dial up connection.
> Can anyone:
> a. support my conclusion that Enterprise Manager is the probable
> cause of the slow connection.
> b. suggest a solution

I don't have a configuration that I easily can test from, but I have a
guess that you could try: for all your remote servers, right-click and
pick Edit SQL Server Registration Properties and uncheck "Display server
state in console".

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Enterprise manager and remote connection

Hi,
I am trying to connect to two different SQL Servers using my broadband inter
net connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server,
but cannot access the SQL Server on another of the network servers. Obviousl
y in Enterprise Manager, I am supplying the IP address in order to connect t
o the SQL Servers, but how
do I differentiate between the two different SQL Servers at the other end an
d connect to both at the same IP address?
Many thanks,
Jonathan SIf the servers are on the same physical machine, then the default instance
listens on 1433 and the other "named instance" would listen on another
port. You'll need this info in order to connect. By default Named
Instances listen on dynamic ports. You'll want to change this to a fixed
port and only allow traffic to this specific port for the second instance.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Enterprise manager and remote connection

Hi,
I am trying to connect to two different SQL Servers using my broadband internet connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server, but cannot access the SQL Server on another of the network servers. Obviously in Enterprise Manager, I am supplying the IP address in order to connect to the SQL Servers, but how
do I differentiate between the two different SQL Servers at the other end and connect to both at the same IP address?
Many thanks,
Jonathan S
If the servers are on the same physical machine, then the default instance
listens on 1433 and the other "named instance" would listen on another
port. You'll need this info in order to connect. By default Named
Instances listen on dynamic ports. You'll want to change this to a fixed
port and only allow traffic to this specific port for the second instance.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Enterprise Manager and named instances

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.
Adam,
in the Client Network utility define an alias which points to your
named instance and define the port number.
M

Enterprise Manager - Meta Data Error

When trying to browse my meta data repository in EM, i
get the following error:
Internet Explorer Script Error
Line: 1
Char: 138
Error: Cannot use parentheses when calling a sub
Code: 0
URL: res://C:\Program%20Files\Microsoft%20SQL%20Server\80
\Tools\Binn\Resources\1033\sqlmmc.rll/repgeneral.htm
Do you want to continue running scripts on this page?
--
After answering yes, you are taken to the next screen and
are not able to update information in the Description and
Comments fields. Everyone else in my group has this
problem too. SQL 2000, sp3. IE 6 sp 1. Now, If i go to
an old machine with SQL 2000 sp 3, IE 5, then I can use
this page with no problems.
Has anyone else run into this. Does Microsoft have a
fix? What should I do other than uninstall IE 6 and
install IE 5. <-- Doesn't sound like a good solution to
me.
Thanks.There's probably a better answer to this, but...
this sounds similair to an issue when using taskpad view. You sometimes get
a similiar message...
in that case if you switch to "large fonts" view and then back to task pad
it works. You might try that. Sorry this wasn't more helpful...
--
Brian
"Brian Mitchell" <brianwmitchell@.hotamail.com> wrote in message
news:059d01c38d9b$976e9580$a001280a@.phx.gbl...
> When trying to browse my meta data repository in EM, i
> get the following error:
> Internet Explorer Script Error
> Line: 1
> Char: 138
> Error: Cannot use parentheses when calling a sub
> Code: 0
> URL: res://C:\Program%20Files\Microsoft%20SQL%20Server\80
> \Tools\Binn\Resources\1033\sqlmmc.rll/repgeneral.htm
> Do you want to continue running scripts on this page?
> --
> After answering yes, you are taken to the next screen and
> are not able to update information in the Description and
> Comments fields. Everyone else in my group has this
> problem too. SQL 2000, sp3. IE 6 sp 1. Now, If i go to
> an old machine with SQL 2000 sp 3, IE 5, then I can use
> this page with no problems.
> Has anyone else run into this. Does Microsoft have a
> fix? What should I do other than uninstall IE 6 and
> install IE 5. <-- Doesn't sound like a good solution to
> me.
> Thanks.|||That is exactly what I was hoping for. I, like everyone
else, have dealt with that annoying problem for a while
now. When I saw the large icons tip in SQL Server Mag a
couple months ago, I rejoiced.
Problem is, that does not help here. It seems obvious to
me that this is a bug that has been introduced by either
IE 6, a service pack, or a security patch.
I know a couple other people have seen this problem. You
will find them if you do a google search. No one has
come up with an answer to it yet though.