Hi,
I am using SQL Server 2005 Analysis Services. I set a time dimension
(server 2000 to 2007). The time dimension uses REFERENCED relationship
with the fact table through a dimension table. When I try to deploy my
project I get the following error:
Error -1056964608 : Internal error: An unexpected error occurred (file
'pcprocbinding.cpp', line 6316, function
'PCDBProcBinding::MapTimeBinding').

FactTable (FTID long)
Dim1Table (FTID long, EventDate datetime)

My Intermidiate dimension is Dim1Table
Referenced dimension attribute = Date
Intermidiate dimension attribute is EventDate

I have no nulls in the Event Date column and all dates are 2001 <
EventDate < 2006.
I've tried removing the 'time of day' part of the dates stored in
EventDate, but it did not make a difference.

Any suggestion will be well appriciated. Do you know what this error
means. Could not find any info in usergroups or documentation.

A materialized referenced dimension using the Server Time dimension doesn't
work. You can either:
- instead of using the Server Time dimension, create Time tables using the
wizard and then build the dimension from the tables created by the wizard
- or make the reference dimension "unmaterialized"

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Tzanko" <tzanko.tzanev (AT) strategicthought (DOT) com> wrote

Thanks Akshai,

I've tried the second option, but the wizard will not allow me to
uncheck the 'materialize' box. It forses me to make the dimension
'materialized'. If I changed the dimention properties manually, it
would not deploy.

I am not sure how I can create a time table with a wizard. How do I do
that. Which wizard should be used?

Akshai Mirchandani [MS] wrote:

What you want is the "Schema Generation Wizard". Basically, just do:

- New dimension

- Select without a data source

- Use a dimension template (Date)

- Go through the wizard

- At the end, select "generate schema"

- Follow the rest of that wizard which allows you to populate a table
in a data source with the data that is generated for the date dimension



Thanks,

Akshai

--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"Tzanko" <tzanko.tzanev (AT) strategicthought (DOT) com> wrote