Unable to select MS Cube in IDT when OLAP connection is created

[Former Member]

Hi experts.

I'm trying to build an OLAP universe on MS Analysis services 2008.

In CMC, I'm able to create the OLAP connection successfully, but in IDT I'm unable to select Cube for the connection (in the Cube selection dialog) because it does not show list of cubes. I've followed the sap tutorial step by step (Information design tool 4.0: Create a connection to an OLAP data source). Please, see next images:

CMC

IDT

Could you tell me if there is something I am missing, please?

System

BO Server: Windows Server 2008 R2

SQL Server 2008

Versión: SAP BI 4.1 SP03

Thanks a lot.

S. Gordon

[amitrathi239]

Hi,

Have you tried  to search the Cube Name or if you select the do not specify the connection and are you able to  get the Finish button.

In your screenshot Finish button is disabled and this will happen when connection is searching the cube.

Regards,

Amit

[Former Member]

Hello Amit,

If I search the Cube Name I get the same behavior.

If I select first radio button (Do no specify a cube in the connection) Finish button is enabled and the test connection is right, but when I'm going to create the business layer I'm facing same problem.

Regards.

S. Gordon

[former_member4998]

Hi

Do you have authorization to select the cubes ? 

[Former Member]

Hi Sreenivasulu, thanks for your quick reply.

Yes, I have authorization, In fact, in CMC I can select the cube, and the same user is used in IDT.