Analysis Service slow

I am attempting to setup a tabular model on my analysis server. I have followed the directions to a key and whenever I add a 2nd table, the queries slow down....really slow. I have created the relationship (orders table customer links to customers table customer). I did notice if you work with the adventureworks and select the orders table, then select "add related tables", it select many other tables. However, on my erp system (which exist in SQL) if I select the orders table and select "add related tables" it does not find any related tables. I know these two tables are linked. If I build a view combining the tables, the view processes very quickly. However, if I create a view to do my analysis, it kinda negates the fact that I am using the analysis service. Does anyone have a suggestion of how to make these queries run faster? Maybe I need to build the relationships in SQL and not using the ERP system. Looking for any suggestion. Thanks One other note, my analysis server is sql 2012 and my erp is on sql 2008...I do not believe that is the issue but just more info
jsgrosskopfIS ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jsgrosskopfConnect With a Mentor IS ManagerAuthor Commented:
After working with Microsoft, they explained I needed to have a measure to make it work. I thought I could simply create the relationships like transact SQL and then run...not the case.
0
 
jsgrosskopfIS ManagerAuthor Commented:
Found out some more information. Even though I created a relationship linking the customer number in one table to the customer number in another, When I select a customer from the orders table, it shows me the name of every customer in the customer table. What could I be doing wrong. I see the relationship...but it's not linking them
0
 
Eugene ZCommented:
check (the same idea for SSAS 2012) SQL Server 2008 White Paper: Analysis Services Performance Guide
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17303

and
SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services   Paper :


Summary: Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a strategy for maintaining and tuning performance. This paper describes strategies and specific techniques for getting the best performance from your tabular models, including processing and partitioning strategies, DAX query tuning, and server tuning for specific workloads

To review the document, please download the Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services Word document.


http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Performance%20Tuning%20of%20Tabular%20Models%20in%20SQL%20Server%202012%20Analysis%20Services.docx
0
 
jsgrosskopfIS ManagerAuthor Commented:
Thanks for the info. However, I think I figured out what my problem is (don't knowhow to fix it). The model is not recognizing or applying my relationship. I grabbed two fields from two tables. Orders (Order Number, Customer Number), Customers (Customer Number, Name). I did a one to many with the customer numbers. if I do a pivot table and select the orders and then add the customer name, it shows me every single customer name for every single order. I cannot figure out why it will not match up my relationship.
0
 
jsgrosskopfIS ManagerAuthor Commented:
Got answer from Microsoft
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.