Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
how to create a new cube based on existing cubes and dimensions? and What is cross cube?

Answered how to create a new cube based on existing cubes and dimensions? and What is cross cube?

  • Monday, January 21, 2013 10:16 AM
     
     
    Sign In to Vote
    0
    How can I create a new cube based on existing cube and dimensions?

    Thanks & Regards, Reddy

     

All Replies

  • Monday, January 21, 2013 3:14 PM
     
     
    Sign In to Vote
    0

    Hello PTReddy ,

      I am not sure quite i understood your question clearly . Could you please brief bit more on the requirment ?

      BTW here are some options for the achieveing this

      1. Script the existing cube using script generator and create a new cube by changing the name.

      2. The dimension .Dim files in the SSAS solution can be used across the cubes under the same database \ solution.

    I have not heard about the terminology CROSS cube. If you are referring to a linked cube , Please read the below link for more details

    http://msdn.microsoft.com/en-us/library/aa216375(SQL.80).aspx

     

    Best Regards Sorna

     
  • Tuesday, January 22, 2013 8:42 AM
     
     
    Sign In to Vote
    0

    Dear Sorna,

    Thank you for your reply.

    My question is, How can we create a new cube based on existing cubes and dimensions?

    For example, there are 3 cubes and 20 dimensions  in my project, customer is asking to create a new cube using those 3 cubes. It it possible to create a new cube using existing cubes?

    Thanks & Regards, Reddy

     
  • Wednesday, January 23, 2013 6:27 AM
     
     
    Sign In to Vote
    0

    Hello PTReddy ,

      Do you mean to use the dimensions and facts from the 3 cubes to create a new cube ? Are you looking for cobining 3 cubes to create cube ? If you can brief with some example it would be helpfull.

    Best Regards Sorna

     
  • Wednesday, January 23, 2013 6:41 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hi Reddy,

    Based on your scenario, you can create a local cube which can be created and populated from either existing cubes in an Analysis Services instance or from a relational data source.

    To create a local cube based on existing cubes, we can use either the CREATE GLOBAL CUBE statement or an Analysis Services Scripting Language (ASSL) script. For more information, please see:

    Besides, there are several considerations you should pay attention to when creating a local cube from server-based cubes:

    • Distinct count measures are not supported.
    • When you add a measure, you must also include at least one dimension that is related to the measure being added.
    • When you add a parent-child hierarchy, levels and filters on a parent-child hierarchy are ignored and the entire parent-child hierarchy is included.
      Member properties are not created.
    • When you include a semi-additive measure, no slices are permitted on either the Account or the Time dimension.
    • Reference dimensions are always materialized.

    For more information, please see:
    Local Cubes (Analysis Services - Multidimensional Data)

    If you need further help on this issue, I suggest that you ask a question in the SQL Server Analysis Services forum where the professionals are more familar with cube issues:
    http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads

    Regards,

    Mike Yin
    TechNet Community Support

     
  • Wednesday, January 23, 2013 6:55 AM
     
     
    Sign In to Vote
    0
    Dear all,

    i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

    year from 2012 year to 2013 date filter 01-01-12..31-12-13

    Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013 

    i need details like this in one report using multiple databases.please anyone help me.


    navya krishna katta
     
  • Wednesday, January 23, 2013 7:07 AM
     
     
    Sign In to Vote
    0

    Dear Mike,

    Thank you for your valuable answers. 

    Thanks & Regards, Reddy

     
  • Wednesday, January 23, 2013 7:08 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hi Naveen,

    Generally, we can use subreport or Lookup() function to combine the data retrieved from different databases in a report. If you need further help, please feel free to create a new question in this forum, and we will continue working with you on this issue in the new thread.

    Thank you for your undestanding.

    Regards,

    Mike Yin
    TechNet Community Support

     
  • Wednesday, January 23, 2013 7:11 AM
     
     Answered
    Sign In to Vote
    0

    Hello Naveen,

    Here I'm looking for answer for my question, but you posted a new question and its not related to my question. Please don't repeat this.

    Any how in reporting services there is a function called LOOKUP, use this function to fetch data from multiple data sets or you can change your data sets to shared datasets so that you can call the fields of different datasets in single report.


    Thanks & Regards, Reddy

    • Marked As Answer by PTREDDY Thursday, January 24, 2013 6:05 AM
    •