Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there folks,
Created a connection to a MySQL server and extracted a fact table. After doing so, stored the table into a .qvd file. What happen next - is that the d_created_time dimension which original structure is 'DD-MM-YYYY HH24:MM:SS' somehow transformed into (please view the image below):
Any ways to fix this problem? Please advise. Thank you.
Best Regards,
R
Can you post few lines of data
Hi Ravi,
Script used:
//Connection to DB
ODBC CONNECT TO [Server DB] (XUserId is userid, XPassword is userpass);
//Extract fact table data
DigiFF_MT_Fact:
Load
i_id,
c_shortcode,
v_target_msisdn,
i_bill_price,
d_create_time;
SQL select i_id, c_shortcode, v_target_msisdn, i_bill_price, d_create_time from digiff.mt;
I am trying to extract the data as it is, storing it into a .qvd file for optimization purposes.
Please advise.
Thanks.
Best Regards,
R
Hi Ram,
You can use like Date(floor(d_create_time),'DD/MM/YYYY') it will work.
if not please post the sample data with QVW.
Regards,
Hi Alok,
Yeah it did work out finally. Cheers.
Best Regards,
R