Ask your BI Questions

[Admin]

Start your BI QUESTIONS

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.

"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