using SSAS 2008 cubes in BOXI 3.0

building reports webintelligence
1

Hi all,

I am new to this toolset. I am trying to build a report based on existing Analysis Services 2008 Cube.

I read up instructions on setting up Voyager and not using a Universe. However they were all related to using the SSAS OLEDB Provider for 2005.

I am going to try the same for SSAS 2008 tomorrow, just kind of wanted to check if anyone has been trying this out?

Thanks in advance,
Neel

iphadke (BOB member since 2008-08-27)

2

I doubt its supported…:slight_smile:

You may have some luck with the 2005 connector, although I’m unsure whether there have been any major mdx changes in the 2008 release…

Mak 1 :uk: (BOB member since 2005-01-06)

3

Hi,

I tried installing the OLEDB SSAS 2008 driver, but no luck. BO didn’t detect it either in Universe Designer or Voyager. However, by using SSAS 2005 driver I was able to generate a Universe.

One question - How to manually create the Universe? Because the automated Classes etc that were generated are not in line with the Cubes and Dimensions, I tried to delete them which happened - but then I saw no way of adding stuff from SSAS Database back to BO Universe… Any ideas?

Regards,
Neel

iphadke (BOB member since 2008-08-27)

4

Hi Neel,

         We have SSAS 2005 cubes. For now we don’t have Voyager or OLAP Intelligence to directly create reports on those cubes. To give a try I am thinking to create Universe on SSAS cubes. We are using Business Objects XI R2 .I don’t see any drivers provided in the Universe Builder.

           As you had already tried this…could you please explain how and what you did to create universe on the SSAS cubes…..as I am in the similar situation where you were….

Thanks
Kiran

She_80 (BOB member since 2007-10-26)

5

Hi all,

We also have a new requirement to use SSAS 2008 as a datasource for both Webi and Voyager. Even with the appropriate 2008 drivers loaded, BO Xi 3.0 doesn’t see the new cubes.

The nice folks at SAP tech support informed us that 2008 is not currently supported and there are no plans to support it with SP1. Our even friendlier sales rep says it WILL be supported in SP1. Go figure.

On a positive note, we have been able to access the 2008 cubes with the 2005 drivers. Universe designer builds the expected structures, and the reporting tools behave properly. Apparently the differences between 2005 and 2008 are fairly minor. I’m not sure I want to go to production with this situation, but we seem to be alright for development.

maxtell :us: (BOB member since 2005-09-23)