Solved

PArtitioning SSAS CUBE by monthly

Posted on 2013-01-14
2
231 Views
Last Modified: 2016-02-18
Hi,

I have 1 million customers in s dimension table and fact table contain monthly cusomters invoices
by each customer, at this moment if I brows the cube by all customer, it started 'no response'
how do I improve this persomance, by intorducing partition?

thanks in advance
0
Comment
Question by:keplan
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 500 total points
ID: 38777292
0
 

Author Closing Comment

by:keplan
ID: 39756095
d
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql 2014,  lock limit 5 45
Sql Server group by 10 48
SQL Database Restore 2008 R2 1 27
query output (script) from a stored procedure 4 33
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question