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
Dynamic cube creation