Need help?

[subbareddykm]

Hi all ,

Can any one tell me how to achieve this ?

I want to convert data  to QVD like >>

KPI Name  ,Company, Year , HalfYear ,quarter ,Value ,Flag.

>>In KPI Name all KPI Names,

>>Company All Company Names i.e XYZ,XYZ1 and XYZ2

>>Half Quarter i.e H1 and H2 should be link with Quarter.

><Quarters i.e Q1,Q2,Q3 Q4  and Years

>> Values should be match with all.

my QVD should be present Like

     KPI Name,

     Compant,

     Year,

     Quarter

     Value

     Flag

[Peter_Cammaert]

Create a QVW document. In your load script, create an internal table with all the required rows and columns. Then perform a STORE of this internal table to QVD. That's about all you need to do.

Best,

Peter

[#3]

Hi reddy,

find the following link

How to create Qvd ?

[#4]

I possiable to share any excel file or total dimensione of that table

[nagarjuna_kotha · Accepted solution]

Hi,

I have seen this post yesterday ,

Create QVW

CRTL +E ,Click on tables select your File and If you want click o next and transpose there you see various options in that.Change based on your requirement.

If you dont want any transpermations  simply select file and Finish it.

-Nagarjuna

[subbareddykm]

Ok,thanks for the response.

let me check.