Ask your BI Questions

View previous topic View next topic Go down

20120728

Post 

Ask your BI Questions




Start your BI QUESTIONS

Admin
Admin

Posts: 10
Points: 17
Reputation: 0
Join date: 2012-07-28

View user profile http://sapbibwhana.forumotions.in

Back to top Go down

- Similar topics
Share this post on: Excite BookmarksDiggRedditDel.icio.usGoogleLiveSlashdotNetscapeTechnoratiStumbleUponNewsvineFurlYahooSmarking

Ask your BI Questions :: Comments

Post on Sat Jul 28, 2012 9:01 pm  kranthikumarsapbi

i have the 10 Aggregates 1 to 9 aggregates it's take time 1 min but 10th one it's take more time how to improve.

Back to top Go down

Post on Sun Jul 29, 2012 2:48 am  Admin

"EVERY PROBLEMS SOLUTION LIES IN ITS ROOTS"

WELL AGGREGATES ARE CREATED TO IMPROVE QUERY PERFORMANCE .

IN YOUR CASE YOU HAVE 1-10 AGGREGATES BUILD ON YOUR CUBE

AT FIRST 10 AGGREGATES ON CUBE INDICATES CUBE HOLDS LARGE AMOUNT OF DATA

1-9 PERFORM QUICKLY IN 1 MIN OF TIME WHERAS THE 10 TH ONE IS TAKING HUGE TIME WHY?

QUESTION TO ASK

WHAT DOES THAT AGGREGATE CONTAINS
HOW MANY CHARACTERSTIS?
DOES MY QUERY HITTING AGGREGATE OR CUBE OR BOTH?

TO ANSWER THESE

PLEASE GO TO RSRT+DEBUG T CODE
TICK SHOW STATISTICS AND PRESS BACK BUTTON
THEN IT WII DISPLAY ALL THE STATISTICS WHICH AGGREGATE IS BEING USED AND FROM WHICH TABLE AND DATABASE

YOU CAN ALSO CHECK IN TABLE RSDDAGGRDIR TABLE

ALSO CHECK THE SIZE OF THE TABLE AND AGGREGATE IF AGGREGATE SIZE IS LARGE AND ALMOST EQUAL TO CUBE THEN QUERY WILL FETCH DATA FROM BOTH

EXAMPLE

YOU HAVE CREATED A QUERY IN IT YOU HAVE TWO KEY FIGURES

KEY FIG 1 HAS FILTER CUSTOMER CHARACTERSTIC
KEYFIG 2 HAS FILTER MATERIAL CHARACTERSTIC

NOW IF YOU EXECUTE RSRT + DEBUG MODE YOU WILL SEE FOR THAT PARTICULAR QUERY DATABASE ACESS AS 2 WHICH MEANS CUSTOMER AND MATERIAL
NOW IF YOU BUILD AGGREGATE KEEPING BOTH CUSTOMER AND MATERIAL IN ONE AGGREGATE THEN QUERY WIL HAVE TO ACESS 2 DATABASES

SO THE SOLUTION WOULD BE TO BUILD TWO SEPERATE AGGREGATES

IN YOUR CASE ANALYSE WHATS THE PROB

IS IT THE SIZE ?
IS IT WITH CHARACTERSTIC
RUN RSRT + DEBUG AND CHECK THE STATS

HOPE YOU FOUND YOUR ANSWER

Back to top Go down

View previous topic View next topic Back to top


Permissions in this forum:
You cannot reply to topics in this forum