About former_member414312

former_member414312

Hello I am having issues with charts that has hierarchy while drilling up and down to it. We randomly get following error message and then report is crashed. Any input will be helpfull. Thanks. "while trying to load from index 16 of an object ar...

former_member414312

Hello All,I would like to convert text to number because we have attributes from master data and in WEBI its considering it as text. e.g.Amount 1,000 CAD2,000 CADResult should be following in order for me to apply calculation on amount. Can you pleas...

former_member414312

Hello,Please help me to correct my code, basically i have to delete the adjacent duplicates records from my source package in BW transformation. When i perform a selective dtp load it works ok but with a full load it does not work. Following is the c...

former_member414312

Hello,Please let me know if there is a SAP function module that can convert timestamp from GMT or provided timestamp into MST. I will need to use this function in BW transformation.Thanks.

former_member414312

Hello,Following is my scenario:I have 2 sub queries within a single report. Depending on the selection criteria of "plant" and "employee" from query1 (based on universe) i need to show records related to the query1 selected "employees" and "plants" i...

former_member414312

issue is fixed now we have created formulas in bex. Thanks Amit for your help.

former_member414312

i have tried and it works ok in English but as soon as we change language to French "#Error" shows up. Any help please? =ToNumber(Replace(Replace(Substr([Amount];1;Pos([Amount];" ")-1);".";"");",";"."))Thanks Amit for your help.

former_member414312

Thankyou so much Amit for your help  It works and round off values, but once the report is converted in French i am getting #Error. It happens once the "Tonumber" is used. .Is there a way i can just swap ,(comma) & .(dot) then convert into number? E...

former_member414312

Hi Jothi, thanks for your reply. My DS is BW and the object is an attribute of MD. I have used replace function to get remove CAD but now i noticed that the format of number needs to be changed also. Example: 25.456,00 Result should be: 25,456.0...

former_member414312

Thank you all for your prompt reply, key point i was missing is "semantic groups" and i have also increased the package size. Problem solved.

User Statistics

User Activity

WEB Intellegence error message while drilling up and down on hierarchy "Error:INF"

Conversion from text to number and Substr

DELETE ADJACENT DUPLICATES help ABAP

Function module required for time stamp conversion into MST

Selection criteria using another webi query

Re: Conversion from text to number and Substr

Re: Conversion from text to number and Substr

Re: Conversion from text to number and Substr

Re: Conversion from text to number and Substr

Re: DELETE ADJACENT DUPLICATES help ABAP