Current Position:Home > Appending Zeros for Characteristic at query level

Appending Zeros for Characteristic at query level

Update:11-30Source: network consolidation
Advertisement
Hi Guys,
Please find the my requirment below.
Customer number (say 1234) should be displayed in query output with two zeros prefixed like 001234.
Is there any way to achieve this at query level.
Thanks & Regards,
Fazil

The Best Answer

Advertisement
Hi Fazil,
I don't think data can be manipulated this way on runtime. You may have to use Virtual Characteristic to achieve the same.
--Priya
  • Appending Zeros for Characteristic at query level Update:11-30

    Hi Guys, Please find the my requirment below. Customer number (say 1234) should be displayed in query output with two zeros prefixed like 001234. Is there any way to achieve this at query level. Thanks & Regards, FazilHi Fazil, I don't think data can

  • Characteristic Value comparison at query level Update:11-30

    HI, I have to identify the invoices as local or upcountry on the basis of below logic. if 0customer->region & country = 0plant->region & country then the invoice is considered as Local Otherwise it is Upcountry.. How can i do this at query l

  • WEB BEx Analyzer Comments on Query level Update:11-30

    I would like to enable BW users to create comments for some queries an enable other user to read them. System BW 7.01. Issues and questions: -how to create comment on query level - it's always on data (KYF), Metadata or Master data level -I would lik

  • HOw to achieve this at report/query level Update:11-30

    Hi Experts Please update me how can i achieve this at query level Lets Consider Data in my Cube Dept_id--Date-- Qty -101.01.20093----- -101.01.20095----- -101.01.20098----- -101.01.20091----- -101.01.20099----- That is how data is avaliable in my cub

  • Convert Char as KF at Query Level Update:11-30

    Hi, I have a query will all line Item Details with GI Date details. But my requirement is the for all line Item details i want the GI date as mentioned for Line Item 10. (i,e First Schedule Line Date) at query level. Is there any way i can convert th

  • Time conversion at Query Level Update:11-30

    Can anyone suggest any methods to convert the time from UTC time zone to PST time zone at Query level without changing at backend level???If it is a key figure you can create a formula and add the offset. If it is a characterisitc and you want to lim

  • Want to convert MMDDYYYY to DDMMYYYY at Query level Update:11-30

    Hi All,          I have done all the user settings for DDMMYYYY format. However till cubel level its coming in DDMMYYYY format. In query its showing MMDDYYYY, is there any setting in Analyzer which i need to do to fullfill the requirement. I have gon

  • Query level filter not working in Webi report Update:10-11

    Hi All, I am using BOXI R3.1 (SP3), m facing one problem when refreshing Webi report on daily basis. I am using three query level filter as a prompt, but i checked one filter is not working then i need to reapply this filter and rest 2 filter is work

  • Date to Month Conversion at Query Level. Update:10-11

    Hi, I have Net due date in the Info provider. At query level i have to create a restricted keyfigure based on Net Due Month. Is there any way i can calculate Net due month at runtime and then create the restricted keyfigure using the net due month in

  • Logical Formula at query level? Update:10-11

    I have requirment like if D =  0 then ' ' (SAPCE) else E / F. I dont know how to get space ? please help me to create this formula at query level?hi Hari, I am not really sure ,but u can try this... if D = 0 then ' ' (SPACE) else E / F. use the same