Hi ,

Is there a way to add a database dimension to a cube using XMLA script?
something like ALTER Table ADD statement in SQL.

I have a database dimension that I would like to add to the cube without
going through the BI dev studio.

Also, I would like to add the dimension/fact tables to the data source view
using the XMLA script.

if it is possible can someone please post some examples?


Thanks,

Sanjay

Just run SSMS and right click on an existing dimension. Then select
"Script... As CREATE".
There is your sample.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sanjay Khadilkar" <sanjayk_nospam (AT) comcast (DOT) net> wrote

I know that but it only generates the CREATE script for a Database
dimension and I want to be able to add the existing database dimension to
the Cube. I don't know how to generate the statement to do that.

So, I am looking for something like ALTER CUBE CUBE ADD DIMENSION DIM1

Sanjay


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

You can click on the dimension object and script out just the dimension
structures. It supports both CREATE and ALTER formats.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sanjay Khadilkar" <sanjayk_nospam (AT) comcast (DOT) net> wrote

I think Sanjay wants the part that actually adds the DB dimension to a cube.
No, you cannot script out an "add dimension" request.

You can write an AMO program to do that very easily, or you can script out
the entire cube with the dimension added...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

In re-reading I agree. Sorry all.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote