Friday, February 24, 2012

Local Cubes Creation...

Hi,

1. Has anyone been able to generate local cubes in SSAS2K5 using XMLA? I run profiler while running a CREATE GLOBAL CUBE but wasn't able to view the relevant XMLA code that creates the local cube.

2. After running a CREATE GLOBAL CUBE on one of our cubes and, while trying to access it using Excel 2003, I am not able to choose a cube (the cube list is empty!!!!).

Thanks,

Joao Bilhim

With regard to (2) - if the Create global cube statement succeeded -it would have created a .cub file in the directory that you specified. You should be able to select it directly in Excel and access it.

No comments:

Post a Comment