Dynamic cube creation 
Author Message
 Dynamic cube creation
I'd like to create a sub-cube from an existing cube. I know I can get the
dimension and level information (using MDSCHMEA_DIMENSIONS and
MDSCHMEA_LEVLES) from the existing cube to specify in the CREATE CUBE
statement. In order to insert data into the new cube, I need information of
joins so that I can specify as join constraint in INSERT INTO statement.

Is there a way to get the join information from a cube using XMLA?

Thanks
Ramesh



Sat, 18 Dec 2004 10:58:01 GMT
 Dynamic cube creation

Ramesh, I am not clear about what do you mean by dynamic cube creation. This
can mean one of the three options:

1. Create session cube from the server cube - It can be achived through
CREATE SESSION CUBE command. No need to know joins. See this whitepaper:
http://www.microsoft.com/sql/evaluation/BI/AnSvcDDL.asp

2. Create local cube from the server cube - See the same whitepaper for
syntax. Again no need to know joins

3. Create cube on the server. This cannot be done through XML/A.

HTH,
Mosha.

--
==================================================
Mosha Pasumansky (moshap at microsoft dot com)
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================


Quote:
> I'd like to create a sub-cube from an existing cube. I know I can get the
> dimension and level information (using MDSCHMEA_DIMENSIONS and
> MDSCHMEA_LEVLES) from the existing cube to specify in the CREATE CUBE
> statement. In order to insert data into the new cube, I need information
of
> joins so that I can specify as join constraint in INSERT INTO statement.

> Is there a way to get the join information from a cube using XMLA?

> Thanks
> Ramesh



Mon, 27 Dec 2004 06:15:53 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Alternative Regular Cube creation besides Cube wizard/Editor method

2. Is there Any C++ syntax/sample for cube creation (.cub)

3. Is any C++ sytax or sample for Cube creation

4. Problem: Define Custom member on local cube creation (Not measures dimension)

5. Creation of local cubes via properties fails ...

6. any guides on this? (cube creation)

7. CUBE - Creation ??

8. basic cube creation

9. Global Cube Creation BUG (675)

10. Analysis Server & Remote Cube Creation Problem

11. Cube creation


 
Powered by phpBB® Forum Software