Search results for query: *

From an MS Analysis Services point of view you'd be best creating the cube from your original databases data. You can then choose where you store the cubes data and aggregations and (as above) whenever you change the source data you can tell the cube to reprocess (which essentially will re-grab...

What are you using to query the data? At it's very simplest level most tools will allow you to hide null data for dimension members which would essentially do what you're looking for... even if they didn't allow you to crossdrill (dependant on how big your dims are I suppose :). If you're...

Is that *because* they allowed duplicate primary keys? :) Mike

Struggling with this... :) We sell 10 products and I have built a cube of the Relational Database that holds our sales (I can't mess with this). My cube has just the one measure which is the NumberSold. A hierarchy dictates which product it was. The problem I have is that I want to write a...

Assuming your running SQL Server 2000: * Create a DTS script * Add a "Analysis Services Processing Task" * Select your server and your cube and decide whether not you want a full process or refresh etc... * Save the package and close it * Right hand click on it and select Schedule Job...

Not really an answer but maybe a workaround... There's an add-in for VB6 that allows you to write an app that processes your cubes. You could customise this to process whatever cube is specified in the command line and then call it in the same manner. Of course if you're having to do this then...

Sometimes it can be something really simple like having two dimension members with the same name. When it gives you the tick boxes (just before the end) asking about "Ordering and Uniqueness" etc. tick them all and answer all the questions it gives you afterwards. You'd be surprised...

It should be on the SQL Server 2000 disc depending on the distribution. Don't ask me about the licensing though! Mike

The software I use creates an XML view of what is essentially an MDX query on the IIS server which other people then play with. Don't know if this would be of any use to you but the software is called Novaview and it's made by a company called Panorama (think they have a demo version - it'd be...

Struggling with this... :) We sell 10 products and I have built a cube of the Relational Database that holds our sales (I can't mess with this). My cube has just the one measure which is the NumberSold. A hierarchy dictates which product it was. The problem I have is that I want to write a...