A quick way to find the repository is to edit the repository connection string.  To do this, righ-click the server in Analysis Manager and select 'Edit Repository Connection String...' ....

Has it had SP3a applied?  If so, where is the repository?  If it's in SQL Server(MSDB in particular) , you may need to be added to the new role created...

obviously it can't log to sql server if it's not running, so alternatives are to log to another server or like you say, put a dependency on the msolap service...

what did u change the connection string to?  are they valid (ie have u checked them from another applciation)?

Take a look at Section 6, Chapter 23 'Business Case Solutions Using MDX' in the SQL Resource Kit (online at http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part1/c0161.mspx).  Do a search on the following 'How Can...

Hey Lee,

Component Checker can only provide a best guess as MDAC is a set of components, hence it checks the versions (of the components) you have and then says well...

Hey Lee,

The s/w's not just laughing at you, it laughs at me also and is sometimes just plain out mean

To get your (parent-child)...

IMHO rs.exe (using vb.net 'scripts' , why no c#?!?) and rsconfig.exe are the most useful of the avail cmdline tools.  Prob i have found is that if I want to...

Personally I think the multi-project issue you've raised will go away as other parties bring out report developing s/w (e.g http://www.cizer.com ).  What you're really trapped in with here...

It's common practice for me

I do it for the same reason you gave, plus if I need to put a where clause to...

Are you creating the dimension from the fact table or from a separate table/view?  I've run into this when dimensions are sourced from the fact table (normally a view for...

We normally add the levels (grouping members) to the view that feeds the dimension. 

When using Yukon you will be able to add these type of calculated fields to the...

Basically yes, that's the way it was hanging together. 

And yes, i think they crossed.

Just out of interest, I was doing this because I had to use someone else's package architecture...

Hey bellis, soory, misread your question...  I would normally set my global var at a TSQL task earlier in the workflow.  So workflow might go like [do something generic] ->...

Say you have a T-SQL task linked by workflow to some other task (say activeX), right-click the second task in the workflow, select Workflow|Workflow Properties. On the second tab (Options)...