need urgent reply

[#1]

Hi..can any one help me this issue ...i am going to create 3 dashboard ..1st dashboard  with 3 months of data and 2nd dashboard with 6 months of data and 3rd dashboard with 1 year data ...for that i am thinking to create 3 qvd's for 3 , 6  and 1 year seperately and then will use those qvd's in respective qvw of dashboard .,  but my issue is that instead of creating 3 qvd's is there any other ways means can restruct in the qvw itself by creating one qvd with whole data?  pls help me this ..

Regards,

Sh.

[Anonymous]

To make maintenance easier I would have one qvw with all the data, and restrict the amount of data being shown within each chart's expressions.

You can create StartDate and EndDate variables and then use set analysis like this:

sum({<TransDate={'>=$(StartDate) <=$(EndDate)'}>} Value)

Jonathan

[tresesco]

While load the data into qvw file (dashborad) you can put a WHERE clause to restrict the data (date wise) for different dashborads.

Something Like:

LOAD

         Date,

         ....

From ... Where Date < 'YourDate' ;

Note: Different Dates for different dashborads from the same source.

[#4]

Hi

Hope at least u have one Transection Table(Put in one qvd)..

Create a Calender Master..

Then ur Dashboard requirement wise extract data from that qvd..3Month,6Month,1Year wise data just calculate in expression lebel.

Regards-Bika

[#5]

Yeah thanks for that reply , but i tried in qvw by loading qvd into that and i gave filter condition after that trying to reload it but nt able to reload getting error ...pls let me know how to use where condition in the qvw(dashboard) level...

regards,

Sh.

FIY..

LOAD

id,

case_number,

createddate,

.......,

......,

.....

from

path.qvd;

[narender123]

You can use where clause in your script

Like'

Load

monthno,

year,

day

from table1 where monthno>=1 and monthno<=3;

or you can write it as

from table1 where month>jan and monthno<=mar;

you can also user date

from table1 where date>=01/01/2013 and date<=01/01/2013;

Thanks

[tresesco]

Load

          Field1,

          Field2,

          Date

From <your qvd path> where Date < '1/1/2013' and Date > '31/6/2012 ;

This will pull six month data. And you can make this conditional load (using where clause) more dynamic based on your rquirement.

[#8]

again thanks , but i tried like that but getting syntax error ...

FYI..

LOAD

Createddare,

ETL_INSERT_USER,
ETL_UPDATE_DATE,
ETL_UPDATE_USER
FROM

where CreatedDate < '1/1/2013' and CreatedDate > '31/6/2012 ;
(qvd);

Pls check it and let me know if i did any mistake ..

Regards,

Sh.

[tresesco]

First look says, CreatedDate and Createddare.......?

[narender123]

Hi,

LOAD

Createddare, 

ETL_INSERT_USER,
ETL_UPDATE_DATE,
ETL_UPDATE_USER
FROM

You have to place where clause just before    ;

Thanks.