Skip to Content
0
Former Member
Jul 01, 2009 at 05:15 PM

Olap Intelligence (Trouble exporting EXCEL)

26 Views

Hi!

Im using Olap intelligence connected to Microsoft Analysis Services 2000. In this Cube i use Row Security, so some Cells are not available for some users. Since the users use Olapi from the Internet, it Is Not possible for them to use ActiveX.

Olapi Example:

Dimension || Value

Country1 14.49

Country2 12.12

Country3 16.3

Country4 #N/A

Country5 20.45

Country6 13.76

"#N/A" shows the cells when they are not available

Olap Intelligence (Viewer HTML) shows the information Correctly, but when i export it to Excel the data are saved only up to the first #N/A

Excel example:

Dimension || Value

Country1 14.49

Country2 12.12

Country3 16.3

Any ideas/solutions for this problem?

Thanks!

Alejandro

Product Information:

BOE XI R2

OLAP Intelligece XI (Viewer HTML u2013 NOT ACTIVEX)

Analisys Services 2000 SP4