How to create QVD from Pl/SQL ?

[#1]

Need Qlikview Script instead of Pl/sql Script..

[nizamsha]

Hi,

Execute your pl/sql procedure or function from your qlikview script.

Your pl/sql procedure should return some result set. In case of function it will return some result set. In case of procedure to return values use ref cursor.

like

connection_string_to_database

Table1:(Qlikview_Sample_Table)

sql

exec sample_procedure;

store Table1 into Table1.qvd;

[#3]

I am having the script of PL/sql and related QVds involved for that script..

I have to convert that into qvscript...

help me on this...

[#4]

What do you need it to actually do ?

Load already stored/queried information, or, something else ?

[#5]

ok, to start with , use the below:

Since GSI_REVENUE_CODE_ID is common in both, the left join() will join both the table on the common field name.

Now this will be similar to

DB Query:

SELECT rd.GSI_REVENUE_CODE_ID, rd.PRODUCT_CODE, rd.PROFIT_CENTER, rd.DUNNING_AREA, rd.COST_CENTER            

                FROM GSI_PRODUCT_REVENUE_MAP prm, GSI_REVENUE_DET rd

                WHERE prm.GSI_REVENUE_CODE_ID=rd.GSI_REVENUE_CODE_ID

QVScript:

GSI_PRODUCT_REVENUE_MAP_tbl:

LOAD

GSI_REVENUE_CODE_ID,

PRODUCT_ATTR_SEG,

PRODUCT_ID,

CHARGE_TYPE,

CUSTOMER_TYPE_ID

..\QVDLocation\GSI_PRODUCT_REVENUE_MAP.qvd

GSI_REVENUE_DET_tbl:

left join(GSI_PRODUCT_REVENUE_MAP_tbl)

LOAD

GSI_REVENUE_CODE_ID,

PRODUCT_CODE,

PROFIT_CENTER,

DUNNING_AREA,

COST_CENTER

..\QVDLocation\GSI_REVENUE_DET.qvd

You can gradually expand the query step by step.

Hope this was helpful.

Thanks,

Angad

[#6]

In all SQL  stmts, I want to display only  these columns , no need of extra columns..

GSI_REVENUE_CODE_ID,

PRODUCT_CODE,

PROFIT_CENTER,

DUNNING_AREA,

COST_CENTER

[#7]

You can drop the unwanted columns by using

drop field/fields statement in script.

[#8]

Hi Angad,

Can you see the above Script it is having lot of conditions..Can you implement that..

Thanks,

Helen

[#9]

As I earlier said,

To transform your query into a QV Script, we would require

>> Knowledge of the whole data model of the application.

>> Understand what exactly the query is doing.

Did you start breaking the query into smaller pieces and tranforming it?

I would suggest you should try doing it by yourself, and let the community know, where you get stuck.

Hope this was helpful.

Thanks,

Angad

[ThornOfCrowns]

This isn't what you asked for orginally and the longer the thread goes on, the more confusing it becomes.

Can you state clearly:

• What you need
• What you have
• What you have tried
• Where it's going wrong

[arsal_90]

Please upload the sample data file and also share the query that u want to translate in qv script and what is the desired result u want from them also share it.