Hi;

I have been trying to create Time Dimension for one of the column in the
table i.e. EntryDate and I am unable to connect the time dimension which I
create using the Wizard using the 2nd option which is Without using data
source. It created a dimension but it is not connected to any data source and
when I process it gives me error, data source is not specified.

I am very new to Analysis service, I am using SQL Server 2005. I want to
create a report where I can show my data by month, by year depending upon the
EntryDate column of a table.

Thanks

--
Essa, M. Mughal
Software Developer
Toronto, Canada

Essa, how do you expect your dimension to be connected to data source
when you are specifically opting for "not using data source"?

Please let me know if I missed some thing.

Thanks

ZULFIQAR SYED

Essa wrote:

AOA Syed;
Let me explain; When I do that i.e connect to data source, It give me option
to select one column to only one Date option, like either to year, to month,
etc. etc. and after that it gives me error there is not hierarichal data
available.

What I need !

1- To show Customer on Y dimension
2- Date on X dimension by year , by month, or by date
3- in the center area we need to show quantity

Lets say , for CustomerA , in Year 2002 the sum of Quantity is 1000
similarly for month....How should I do that !

I do have Customer Table, Order Table with Order Entry Date.

It is not actual example, we do have other parameters but same concept.

Thanks

--
Essa, M. Mughal
Software Developer
Toronto, Canada


"ZULFIQAR SYED" wrote:

Essa,

Here is a code sample based on AS2005 Adventure Works sample on how you
show the customer, year, and quantity.

SELECT
[Date].[Calendar].[Calendar Year].&[2001]
ON 0,
[Customer].[Customer Geography].[Customer].&[18702]
ON 1
FROM
[Adventure Works]

HTH..

ZULFIQAR SYED
HTTP://ZULFIQAR.TYPEPAD.COM

Essa wrote: