Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
SAP BW team has created a process chain and used two variants one for start(var_start) and one for end(var_end).
Now I need to read those variants details like date and time stamp into qlikview.
Please help on the same.
Thanks in advance.
When you call "Variant" in SAP i believe they created 2 nodes for you to pull data with different business. So, Here we were load 2 instances and/or variant of each to call them up into Qlikview. So, This is how you need SAP connector by SAP platform provider.
SAP Connection String ...
Variant1:
Load ....
Either one here Join / Concatenate
Variant2:
Load ...
From here, There is 2 manipulation as needs, If we are focusing on SQL as mediator of-course, It Would need SQL functions to change from current stamp to required like To_Char() ...
SELECT Date_Format(var_start, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;
SELECT Date_Format(var_end, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;
Meantime, I have one free offer for you, If we are loading using Qlikview LOAD statement there should be this?
SELECT TimeStamp(var_start, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;
SELECT TimeStamp(var_end, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;
So, Finally you need to understand the business to create perfect Data model for 2 instances and other dimensional tables.
hi Anil,
Thank you for the reply.
do you know in which table this variant details will be stored in sap?
Please help.
This is QlikView forum not a SAP.
FYQ, There is table name called "/SAPAPO/RTSINPUT_CUBE" if you have one variant it will store with in the table. And it you have many variants like you said there is Table called VARID, FM -"RS_VARIANT_CONTENTS"
So, Finally my question does your table is Transaction Data or Business data
You cannot get the variant values directly from SAP Table, First get variant name from VARID table and then use this from RS_VARIANT_CONTENTS like i said first sentence.
If this data has Transaction fields i believe we will get SHDTV Table in SAP (Just for assumption)
Are you fetching data from SAP Z reports?
This variant are not stored in any table.