How to script a cube to move it from Development to Production


    Sponsored Links


  • 1. Displaying Images in OLAP Cube
    I'm somewhat new to SQL Analysis and setting up cube analysis from various SQL data tables. My client is interested in being to display a graphic image in the cube answer rows as the various dimensions change. In other words, as you add or change various dimensions in the cube, the resulting display would not only display an Item Number, or an Item Description, but a graphic of the product itself. This image could either be a field in the SQL data table itself, like a BLOB ield, or it could contain a path name to a directory where the image is stored. Do you know if the SQL OLAP Analysis could do this, or perhaps any 3rd party products that do? Much thanks, Bill R. Rosman Computing Chicago, IL
  • 2. Calculated Members, Hierarchies... lost
    My apologies, I'm new to OLAP and have a problem I can't seem to figure out and was hoping someone can help. My scenario is simple. I have a parent-child hierarchy dimension that is referenced in a MS 2008 cube. I only enter values in the cube matching the lowest level hierarchy items or possibly the next level up. I believe I created the calculated members correctly since I can view the values rolled up in SS Management Studio by browsing the cube and dragging the hierarchy dimension over. The problem I have is I want to show, from specific node (top perhaps) and the next n levels down, the calculated cube values and the entries in the hierarchy that correspond to them. I tried using descendants but all I get is the top node and where I expected values rolled up in some nodes I see null's. Here's how I query for 5 levels down starting at the top. SELECT Measures.[TestValue] ON 0, Descendants( [Hier].[ItemName].[All], 5, SELF_AND_BEFORE ) ON 1 FROM [TestCube] If I go far enough down in the tree or I wrap descendants in NonEmpty I see the top "All" node and my two test values from the cube. I use a calculated member along with a custom member column in my hierarchy and like I mentioned it seems to work if manually browsing with SSMS. Any help would be appreciated as I'm lost on this. Thank you.
  • 3. Wrong calculation of defined members with divisions
    Hi there, to make it simple I have a member [DIM1].[xy] as [DIM1].[x] / [DIM1].[y] and another member [Measures].[QtD] as ({[TIM1].CurrentMember.lag(2): [TIM1].CurrentMember},[Measeures].[Value]) Unfortuantely I habe no time-Dimension so that I have to calculate QtD as a defined member (it's much more complex). Now I put [Measures].[QtD] to columns and [DIM1].[xy] to rows. I'd like MDX to calculate ([DIM1].[x],({[TIM1].CurrentMember.lag(2):[TIM1].CurrentMember}, [Measeures].[Value])) / ([DIM1].[y],({[TIM1].CurrentMember.lag(2):[TIM1].CurrentMember}, [Measeures].[Value])) but MDX calculates ([DIM1].[x],([TIM1].CurrentMember.lag(2),[Measeures].[Value])) / ([DIM1].[y],([TIM1].CurrentMember.lag(2),[Measeures].[Value])) + ([DIM1].[x],([TIM1].CurrentMember.lag(1),[Measeures].[Value])) / ([DIM1].[y],([TIM1].CurrentMember.lag(1),[Measeures].[Value])) + ([DIM1].[x],([TIM1].CurrentMember,[Measeures].[Value])) / ([DIM1].[y], ([TIM1].CurrentMember,[Measeures].[Value])) which is wrong. I played with solve_order but nothing changed. How can I tell MDX to calculate the other way? Cheers Matthias

How to script a cube to move it from Development to Production

Postby karenmiddleol » Thu, 18 Aug 2005 22:06:14 GMT

I have one cube in Development AS instance and I want to migrate it to
the production AS instance.

Unfortunately, the two databases are not the same I want to only move
the cube from Development to production.

Is there a scripting tool that can gather the DDL for the cube,
calculated measures so I can recreate this in the production AS

I cannot find anything useful out there to help in the migration.

Please help


RE: How to script a cube to move it from Development to Production

Postby QnJpYW4gQWx0bWFubg » Fri, 19 Aug 2005 00:37:57 GMT

Try the DSO-XML conversion utility:



Re: How to script a cube to move it from Development to Production

Postby Dave Wickert [MSFT] » Fri, 19 Aug 2005 05:33:37 GMT

There is an extensive discusson of this topic in the AS Operations Guide:
under the topic Release Management.
Dave Wickert [MSFT]
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)

Similar Threads:

1.How to move DTS packages in Development server to Production - scripting

We are changing current DTS packages in Development or building new
ones in Development.

The only way I have realised to move DTS packages from Development to
Production is by saving them into structured storage files and
uploading and saving it into Metadata on the production Server. But
then I need to manually redo all connections to the source or target in
production server and then I make another change in development I need
to redo this again.

Is there a better way of doing this ? Please help
Can we have the system automate the source to target mapping, scripting
the package,etc.

Karen way to move database from development to production


What's the best way to move a database from development server (once you 
have done all the testing and everything runs fine) to the production server? 
Thanks in advance.

3.Moving from Development Server to Production Server

I will be moving my RS to a production server in a week or so. I would like 
to ask if anyone has had experience with this, and if so could they share any 
pitfalls that they came across.

Specifically I would like to know if you had to handle anything releated to 
the symmetric keys.

My current install on my dev machine (itddev05) is running as a service 
using the: NT Authority\NetworkService account.

If I install a new instance on the production machine and use the same 
account will the keys match up, or do you think I will need to import the 
keys from my install in the dev machine?

The application that I'm renders reports uses the SOAP API call with the web 

4.How to move cube and dimension changes to Production

We are routinely getting requests from users to add new dimensions or
measures into cubes or add calculated members.

We develop and test the changes in our Development server and manually
are redoing all these changes in Production server again.

Is there a scripting option available in Analysis Services like in the
SQL Server DB where we just capture the tables, indexes or stored
procedures in scripts and apply the script in production server to move
the new incremental changes from Development to Production.

I could not find much help on scripting cubes, calculated members or

Please help


5.Scripting a cube- Stuck in creating the cubes from the scripts

Hi there,
I have managed to install the DSO-XML utility, the problem here is how do i 
run the xml scripts to create the cubes.........How is this done?and where do 
i need to run the xml scripts?Please clear my doubts ?


6. SQL Profiler - script changes by EM in development - run script ag

7. Database Environment Naming Production -vs- Development

8. Refresh data from production to development



Who is online

Users browsing this forum: No registered users and 81 guest