Determining Security: examples

I was trying some of the examples in VS. However, I can't seem to be able t
o connect to the pubs database. As you know from the title, I use a sql2ksp
3 on a win2k machine. I've searched the MSDE, and they said something about
dropping the localized ver
sion to the US version with an isql command, which doesn't seem to work in t
his case for the fact that isql command doesn't exist.
Can anyone help me?
Thanks in advance. ^_^You can get pubs and Northind here
EBC53A68034&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Spenze" <anonymous@.discussions.microsoft.com> wrote in message
news:80C956E0-A3A6-4003-91C1-273B0045AD75@.microsoft.com...
> I was trying some of the examples in VS. However, I can't seem to be able
to connect to the pubs database. As you know from the title, I use a
sql2ksp3 on a win2k machine. I've searched the MSDE, and they said
something about dropping the localized version to the US version with an
isql command, which doesn't seem to work in this case for the fact that isql
command doesn't exist.
> Can anyone help me?
> Thanks in advance. ^_^

How can I automate aggregation design of a cube in Analysis Services

using XMLA.

I tried following XMLA.

I am not getting any examples for XMLA for Aggregation

design, please help me

===================================================

<DatabaseID>Adventure

Works DW</DatabaseID>

<CubeID>Adventure

Works</CubeID>

<MeasureGroupID>Internet

Sales</MeasureGroupID>

<PartitionID>Inernet_Sales_2001</PartitionID>

</Object>

</DesignAggregations>

</Command>

</PropertyList>

</Properties>

</Execute>

===================================================

Regards

Here's a couple of scripts i was mucking around with. i've split them into 1, 2 and 3 (ie numbered in the orderr in which i ran them). They may give you some pointers to where you want to go.

Sorry about the formatting, i've just pasted them in here and it seems to go on forever.....

Script 1 - Create Aggregation Design for Measure Group --

<!--

XMLA_Creates_Aggregation_Design_for_Measure_Group

This script adds the aggregation design to the measure group

-->

<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ParentObject>
<DatabaseID>Aggregation Testbed</DatabaseID>
<CubeID>Adventure Works</CubeID>
<MeasureGroupID>Internet Sales</MeasureGroupID>
</ParentObject>
<ObjectDefinition><AggregationDesign>

<ID>AggregationDesign 1</ID>

<Name>AggregationDesign 1</Name>

<CubeDimensionID>Order Date Key - Dim Time</CubeDimensionID>

</Attribute>

<AttributeID>Calendar Year</AttributeID>

</Attribute>

<AttributeID>Calendar Semester</AttributeID>

</Attribute>

<AttributeID>Calendar Quarter</AttributeID>

</Attribute>

<AttributeID>Calendar Month Number</AttributeID>

</Attribute>

<AttributeID>Calendar Month Name</AttributeID>

</Attribute>

<AttributeID>Fiscal Year</AttributeID>

</Attribute>

<AttributeID>Fiscal Semester</AttributeID>

</Attribute>

<AttributeID>Fiscal Quarter</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Number</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Name</AttributeID>

</Attribute>

</Attributes>

</Dimension>

</Attribute>

<AttributeID>Calendar Year</AttributeID>

</Attribute>

<AttributeID>Calendar Semester</AttributeID>

</Attribute>

<AttributeID>Calendar Quarter</AttributeID>

</Attribute>

<AttributeID>Calendar Month Number</AttributeID>

</Attribute>

<AttributeID>Calendar Month Name</AttributeID>

</Attribute>

<AttributeID>Fiscal Year</AttributeID>

</Attribute>

<AttributeID>Fiscal Semester</AttributeID>

</Attribute>

<AttributeID>Fiscal Quarter</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Number</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Name</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Delivery Date Key - Dim Time</CubeDimensionID>

</Attribute>

<AttributeID>Calendar Year</AttributeID>

</Attribute>

<AttributeID>Calendar Semester</AttributeID>

</Attribute>

<AttributeID>Calendar Quarter</AttributeID>

</Attribute>

<AttributeID>Calendar Month Number</AttributeID>

</Attribute>

<AttributeID>Calendar Month Name</AttributeID>

</Attribute>

<AttributeID>Fiscal Year</AttributeID>

</Attribute>

<AttributeID>Fiscal Semester</AttributeID>

</Attribute>

<AttributeID>Fiscal Quarter</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Number</AttributeID>

</Attribute>

<AttributeID>Fiscal Month Name</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Customer</CubeDimensionID>

</Attribute>

<AttributeID>Country-Region</AttributeID>

</Attribute>

<AttributeID>State-Province</AttributeID>

</Attribute>

</Attribute>

<AttributeID>Postal Code</AttributeID>

</Attribute>

<AttributeID>Education</AttributeID>

</Attribute>

<AttributeID>Email Address</AttributeID>

</Attribute>

<AttributeID>Gender</AttributeID>

</Attribute>

<AttributeID>Marital Status</AttributeID>

</Attribute>

<AttributeID>Occupation</AttributeID>

</Attribute>

<AttributeID>Phone</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Product</CubeDimensionID>

<AttributeID>Product Name</AttributeID>

</Attribute>

<AttributeID>Product Line</AttributeID>

</Attribute>

<AttributeID>Model Name</AttributeID>

</Attribute>

<AttributeID>Subcategory</AttributeID>

</Attribute>

<AttributeID>Category</AttributeID>

</Attribute>

<AttributeID>List Price</AttributeID>

</Attribute>

</Attribute>

<AttributeID>Weight</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Currency</CubeDimensionID>

<AttributeID>Currency</AttributeID>

</Attribute>

<AttributeID>Currency Code</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Sales Reason</CubeDimensionID>

<AttributeID>Sales Reason</AttributeID>

</Attribute>

<AttributeID>Sales Reason Type</AttributeID>

</Attribute>

</Attributes>

</Dimension>

<CubeDimensionID>Internet Sales Order Details</CubeDimensionID>

<AttributeID>Sales Order Key</AttributeID>

</Attribute>

<AttributeID>Sales Order Number</AttributeID>

</Attribute>

<AttributeID>Sales Order Line</AttributeID>

</Attribute>

<AttributeID>Carrier Tracking Number</AttributeID>

</Attribute>

<AttributeID>Customer PO Number</AttributeID>

</Attribute>

</Attributes>

</Dimension>

</Dimensions>

</AggregationDesign>

</ObjectDefinition>

</Create>

-- End of script 1 :)

Script 2. - Add/link the aggregation Design to the Measure Group --

<!--

XMLA_Adds_Aggregation_Design_To_Partition

This script adds the aggregation design to the partition. It requires the aggregation design to have been

created for the associated Measure Group

-->

<DatabaseID>Aggregation Testbed</DatabaseID>

<CubeID>Adventure Works</CubeID>

<MeasureGroupID>Internet Sales</MeasureGroupID>

<PartitionID>Internet_Sales_914</PartitionID>

</Object>

<ID>Internet_Sales_914</ID>

<Name>Internet_Sales_914</Name>

<Name>LastOrderDateKey</Name>

</Annotation>

</Annotations>

<DataSourceID>AdventureWorksDW</DataSourceID>

<QueryDefinition>SELECT * FROM [dbo].[FactInternetSales] WHERE OrderDateKey <= '184'</QueryDefinition>

</Source>

<StorageMode>Molap</StorageMode>

<ProcessingMode>Regular</ProcessingMode>

</ProactiveCaching>

<AggregationDesignID>AggregationDesign 1</AggregationDesignID>

</Partition>

</ObjectDefinition>

</Alter>

-- END OF SCRIPT 2 :)

Script 3. - Run the designer to build the aggregation designs themselves (ie the aggregations, but not populated with data, this happens when you build the partition and/or cube).

<!--

XMLA_Runs_Aggregation_Engine_to_Determine_Aggregations

This script runs the aggregation engine that uses the supplied parameters to build an aggregation design

-->

<DatabaseID>Aggregation Testbed</DatabaseID>

<CubeID>Adventure Works</CubeID>

<MeasureGroupID>Internet Sales</MeasureGroupID>

<AggregationDesignID>AggregationDesign 1</AggregationDesignID>

</Object>

</DesignAggregations>

-- END OF SCRIPT 3 :)

Hope you find these of use.

Steve.

Wednesday, March 7, 2012

desktop sql2ksp3 pubs

desktop sql2ksp3 pubs

Tuesday, February 14, 2012

Design Aggregations using XMLA

Determining Security

Blog Archive

About Me