New partition using XMLA

Hi,

I have an existing cube containing a single partition.

I am running the following xmla script to create a new partition :

<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<ParentObject>

<DatabaseID>myDB_id</DatabaseID>

<CubeID>mycube_id</CubeID>

<MeasureGroupID>mymg_id</MeasureGroupID>

</ParentObject>

<ObjectDefinition>

<Partition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ID>mypartition_M1</ID>

<Name>mypartition_M1</Name>

<Annotations>

<Annotation>

<Name>AggregationPercent</Name>

<Value>30</Value>

</Annotation>

</Annotations>

<Source xsi:type="QueryBinding">

<DataSourceID>myDS_id</DataSourceID>

<QueryDefinition>

SELECT blabla...

</QueryDefinition>

</Source>

<StorageMode>Molap</StorageMode>

<ProcessingMode>Regular</ProcessingMode>

<ProactiveCaching>

<SilenceInterval>-PT1S</SilenceInterval>

<Latency>-PT1S</Latency>

<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>

<ForceRebuildInterval>-PT1S</ForceRebuildInterval>

<AggregationStorage>MolapOnly</AggregationStorage>

<Source xsi:type="ProactiveCachingInheritedBinding">

<NotificationTechnique>Server</NotificationTechnique>

</Source>

</ProactiveCaching>

<EstimatedRows>1000000</EstimatedRows>

<AggregationDesignID>AggregationDesign</AggregationDesignID>

</Partition>

</ObjectDefinition>

</Create>

My partition is created and I can see it into SQL Server Management Studio.

I can process it as well and everything looks fine.

The only problem is that I cannot see the partition in BIDS which is quite strange....

Any ideas ?

Regards,

JL

BIDS works against project. Unless you made changes to the project - it won't see the changes on the live server. You can create new project by using "Import" option - i.e. create project from current server state. Or you can also work in "online mode" by doing File -> Open -> Analysis Services Database.|||

Mosha,

Thx a lot !

JL