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