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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jsgrosskopfIS ManagerAuthor Commented:
Got answer from Microsoft
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.