Did you try ParallelPeriod? If so (and it didn't work) what was/were the issue(s) encountered?

Ok, now i am really interested..... you wrote procs to load columns to the dims?? Can you post a small piece of one of these? Also, any...

Not sure it's super clear (to me anyways 😉 ) but what Ben suggested would let you create one larger cube (which you can make visible to your users, if...

Another question/point - did you not use the UI in SSAS to drag and drop cols to make your dims?? not sure either re: your reference to writing a...

Must admit i have a penchant for the transformer UI also, but have no issues moving between the two (ie SSAS 05/08 takes at most 5% longer than Cognos). ...

You could use CubeSlice (link) to create one (or many) local cubes, though it must have been a while since I visited as I don't remember the price being that...

Do a search for ASSP (analysis services stored procedures) - it's a project on Codeplex. You can add these SP's (it's a compiled managed library) to your AS instance...

Hi, it's not MDX just TSQL (assuming a sQL server backend/data source). If you look in Books online for LEFT you'll find severl examples. TO use this...

or, you could add a new field to your view over the dimension table (assuming you're using views) where you do a LEFT(Customer_name, 1) AS Customer_First_Letter which will give you...

My bad :S Yes, if you're recording it as a -x, and they haven't truly returned x units, then that sounds wrong to me. Where possible, your data...

Your approach sounds correct to me, the dollars will all reconcile, the qty will reconcile, it's only the avg price calc that is potentially going to cause you issues, and...

Haven't seen any specific Imp to RS converters. I owuld recommend reviewing the Imp Catalog in detail, determine how close it is to the actual DB schema. You'll...

Can you tell from any VPN logs whether specific ports are being blocked? Alternatively, have the admins who set up the VPN specifically allowed/denied a set of ports e.g....

You mentioned that Windows Integrated is checked, is the Allow Anonymous unchecked? THis will override the windows auth if it is checked.

DSV == Data Source View (in analysis services 2005 onwards).

The arrow is used to indicate the direction of the relationship. You should be settings these up where the non-arrow...