In the cube editor, check the visible property of the cube. Sometimes when you do a re-install this gets flipped to false. If it is set as false, change it...

The amount of time it takes for the OWC Pivot Control to display data depends to an extent on your cube aggregation design. If you are selecting dimensions (and measures)...

Okay, I ran the package as a job and it executed fine except the incremental filter is still not being set. When I open the package logs there are no...

Both the SQL Server and AS are version 8.00.760 (SP3). I am running the job now with package logging turned on and will let you know what I come up...

Thank you, Scot. I added the SQLCmdAgentExec to the OLAP Administrators group and also changed the user that the SQLCmdAgentExec logs in as to my user name (I am a...

Thank you, Scot. No, there are no other tasks that modify an AS task in the package...the one in question is the only one. Do I need to make the...

Thank you, Johnny...I had the execute on main thread option checked but had never enabled the close connection on completion option...I will try that and post the results.

Thanks again,

Michael Weiss

Yes, you could create your own star schema and it would in fact be a data mart or data warehouse. As for scrubbing tables, if you are moving data from...

A cube has to pull data from some source. This source can be a relational db or a data mart or data warehouse. In your example of books, customers, and...

Thank you, Andy. The web service approach Steve suggested is sounding better every minute!

Michael Weiss

Thank you...I like the sounds of both of those ideas and will give them some thought. Yes, you are correct in your assumption that both the UI and the...

I would guess that you are passing a value that is of a different variable type than what it expected by a parameter or a destination field.

hth,

Michael

Michael Weiss

Have you tried commenting out one line at a time and running the procedure to see which line is actually causing the error? You can do this by putting a...

I went ahead and deleted the variables in question and recreated them...I will check and see if that did the trick when the package runs next. Thanks for the suggestions...

I have no reason any changes were made either to the package itself or on the client. This is a package that I had problems with two global variables being...