Dimension [Fact Internet Sales] : Create hierarchies in non-parent chi

  • yrstruly

    SSCrazy

    Points: 2805

    Hi, Please Assist? I am trying to deploy a cube and it gives me a few errors. How do i correct?

    I am using the AdventureworksDW2012.

     

     

     

     

     

     

  • Matthew Cushing

    SSCrazy

    Points: 2898

    Can you include the errors?  The screenshots only show the warnings.

  • yrstruly

    SSCrazy

    Points: 2805

    Thats everything that contains that its not working. When i press process it gives the usual message of "Server Content Out Of Date" and than "There were errors during building tland deployment"

  • Matthew Cushing

    SSCrazy

    Points: 2898

    Try processing your dimensions first, and if that goes through without a problem, then process the cube.

    Make sure with both dims and cube that you do process full.

  • yrstruly

    SSCrazy

    Points: 2805

    Please eleborate, im new to this?

  • Matthew Cushing

    SSCrazy

    Points: 2898

    🙂  No worries.

    Just an FYI, I'm certainly no expert at cubes, to begin with, but here's what I know.

    If you right click on one of your dimensions, you should see an option for 'Process'.  When you click Process, it'll do some work and a screen will popup with a process button.  Before you do, look at the top of the window that popped up and see if it says Process Full or Process Update or something like that.  Pick Process Full, and let it do the work.  Do that for all of them.  Alternatively, you can choose all of them and choose process and then change them all to Process Full if it doesn't come up that way.

    Once you've processed them all, then right click on the cube and process the cube, again when it asks, choose Process Full.

  • yrstruly

    SSCrazy

    Points: 2805

    My server is running i have connected to it.

  • Matthew Cushing

    SSCrazy

    Points: 2898

    Where are you running SSAS?  Local or on a remote server?  My assumption is that it's local based on what your screenshot says.  If that is the case, do you have Analysis Services running on your local box?  If you don't, I don't think this is going to work.

     

    Have you looked into the Stairways here on SQLServerCentral.com and looked for an SSAS one?  They have good stuff to look at.

     

  • yrstruly

    SSCrazy

    Points: 2805

    All is running and its local.

  • yrstruly

    SSCrazy

    Points: 2805

  • Matthew Cushing

    SSCrazy

    Points: 2898

    if you've got the properties of the project set up - build and deployment screens are correct, check out this post. - https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3a5f79d-8c7d-40e1-b726-b7bf0dd828d3/a-connection-cannot-be-made-ensure-that-the-server-is-running?forum=sqlanalysisservices

    I'm hoping that someone else will jump in here because you've exhausted my SSAS knowledge :).  What made you ask me on Twitter to take a look?

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply