Re: XMLA/ASSL help AS2005

Tech-Archive recommends: Speed Up your PC by fixing your registry

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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message
news:eK%23HgUC$FHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:OlxoTr4%23FHA.516@xxxxxxxxxxxxxxxxxxxxxxx
>> Just run SSMS and right click on an existing dimension. Then select
>> "Script... As CREATE".
>> There is your sample.
>> --
>> Dave Wickert [MSFT]
>> dwickert@xxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxx> wrote in message
>> news:%231O4ent%23FHA.140@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: XMLA/ASSL help AS2005
    ... I think Sanjay wants the part that actually adds the DB dimension to a cube. ... you cannot script out an "add dimension" request. ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005 missing data at top level.
    ... I copied the database to a development server and create the script for the ... Then I delete the dimension and recreate -it and bind ... it in the cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: XMLA/ASSL help AS2005
    ... 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 ... I am looking for something like ALTER CUBE CUBE ADD DIMENSION DIM1 ... >> Is there a way to add a database dimension to a cube using XMLA script? ...
    (microsoft.public.sqlserver.olap)
  • Re: dimension tables in AS2005
    ... (this generate the XMLA script required to create the object) ... change the name of the dimension and the ID ... do you work in connected mode? ... you have to use XML/A script in the management studio to create a new ...
    (microsoft.public.sqlserver.olap)
  • Re: dimension tables in AS2005
    ... (this generate the XMLA script required to create the object) ... change the name of the dimension and the ID ... do you work in connected mode? ... the database to the server later. ...
    (microsoft.public.sqlserver.olap)