Optimization Tips Required

[noman212]

Hi Communtiy,

I want to optimize my Data for QVW.

Currently when i selected multiple years and month selections its stuck and go into not responsding mode.

i had son concatenated field there which i used as a KEY in table and at expression levels it perform aggr function.

Please suggest some technique to optimize the data.

Awaiting your reply.

Regards

[stabben23]

Hi,

To use aggr as expression could be very memory expensive. All Depends on Your datamodel and how these Dimensions in Connected to the fact transactions. Could you perhaps show us the Application.

Are you shure that  Year and month is Connected to Your fact table?

[nagarjuna_kotha]

Check Follow below Reasons:

1.Apply conditional show to that chart Example: After selecting Year and month the chart should display.

2.u can also Create Ad-hoc report for such cases.

3.If you have calculated dimensions in your chart , try to create those in backend and use them.

4.if you are using Set Analysis in ur expressions , use  Set Analysis.

I Hope this might helps you.

-Nagarjun

[nagarjuna_kotha]

there shouldn't be calculated dimensions, aggr-functions or nested if-loops) but the best way would be to reduce the number of dimensions and expressions. 20 + 10 = 30 columns is far more as it would be sensible.

I Hope this might helps.

-Nagarjun

[noman212]

Please find the attached data model with facts and dimensions tables.

CAn you please explain how can i assign concatenated fields with fixed numbers

like if i have a QVD from which i used two fields as a key

For Example :

Table A :

ID,

A,

B,

from Table A,qvd(qvd);

from above table i concatenate 2 fields as a key.

Table A :

ID & A as KEY,

A,

B,

from Table A,qvd(qvd);

I want to assign a permenant number against each product for dimensions tables can u please help me to assign fixed number to each product currently in qvd we have almost 32B data against 4 to 5 qvds.

[noman212]

nagarjuna.kothamandi

[stabben23]

Hi,

i'm not sure what you want to achieve, but if you want to use concatenated keys, the keys must be concatenated With the same Field also in the Dimension table. I can also see that you have some "leavs" (xxxshop and one more), maybe use applymap so the Fields will be in one table.

Concatenated keys should be on the lowest granularity.