Hi,

AS2005 features includes Data Source Views the Core component of
AS2005. But when you define the data source views you select the
required tables such as fact and dimension tables.
But my question is if i am creating dynamic partitions based on
time(monthly) or region wise i would be creating the required partition
tables at the back end which will not be available in the created
datasource view in UDM.
Can any body explain how would i include them in the Datasource view.

In AS2000 i would have used DSO code to do the same Now i may need to
use AMO for the same.
Can any body please let me know any link which helps me to understand
better to use the AMO for the same.
I could not find much better help in books Online on AMO

I would highly appreciate immedeate response.

Regards,
Prasanna

The following white paper might have some useful information
http://www.microsoft.com/downloads/d...displaylang=en

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"pras" wrote:

Another point to make is that when you are using partitioning you probably
shouldn't be loading from an object in the DSV. You need to have one object
in the DSV to create the measure group, but after that you are better of
using either:
1) a table binding against a table in the data source directly -- not using
the DSV, or
2) better, yet, using a query binding against the data source and you can
put whatever you want in the SQL statement so long as the column names match
the column names from the table in the DSV used to create the measure group.
I have a write paper in the works that talks about this -- but if you are in
a hurry, look at Webcast #2 of 3 in the Project REAL series (look at the
bottom of this web page) -- i have a cool demo there.
See: http://www.microsoft.com/sql/bi/Proj...L/default.mspx

Hope that helps.
--
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.


"pras" <prasannat (AT) gmail (DOT) com> wrote

Thanks Dave,
I will go thru the document pionted by you and also the Webcast.But
still the Books online with the Beta3 doesn't have all the things which
can be addressed. if you can provide with me the link for full fledged
BOL 2005 is highly appreciated

If i have query i will post it again.

Regards,
Prasanna

Dave Wickert [MSFT] wrote:

Thanks Dave,
I will go thru the document pionted by you and also the Webcast.But
still the Books online with the Beta3 doesn't have all the things which
can be addressed. if you can provide with me the link for full fledged
BOL 2005 is highly appreciated

If i have query i will post it again.

Regards,
Prasanna

Dave Wickert [MSFT] wrote:

The Sept CTP which will be available in a week or so at PDC will have as
complete a BOL as you will see for RTM.

Attached are three scripts.
1) dsv.xmla shows a partition created against an object in the DSV.
2) tablebinding.xmla shows a partition created against a table in the
datasource (doesn't exist in the DSV at all).
3) querybinding.xmla show a partition created against an adhoc SQL query
which may or many not exist in the DSV, data source, or anywhere. It will be
issued against the data source, but may reference tables (with 3part and
4part naming) anywhere.

Hope that helps.
--
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.


"pras" <prasannat (AT) gmail (DOT) com> wrote

Hi Dave,
I have allready registered but stiill i am unable to see the webcast.My
e-mail also got verified after that i haven't recieved any mail from
Microsoft for downloading the files or seeing the webcast.
I am very eager to see the webcasts.

please help

Regards,
Prasanna

The complete set of webcasts can be downloaded from:
http://download.microsoft.com/downlo...L_Webcasts.exe


--
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.


"pras" <prasannat (AT) gmail (DOT) com> wrote

Thanks Dave

Dave Wickert [MSFT] wrote:

Hi Dave,

Thanks Dave for the stuff, the webcasts are really excellent.This is
more than a demo giving good insights into the new features brought in
SQL Server Business intelligence 2005 (Yukon)
Can you please me the links for downloading the DTS Integration
packages and other good stuff. SO that i can download them.

Regards,
Prasanna