Hi all, The above script is not displaying +ve values for the second condition. It's displaying -ve values from 1st and 3rd row. Regards, Chandra.

Not the same questions, but both are asked by me only.

Hi All, I have the following scenario of measure column data. When i select ALL in the prompt it has to show all the data (4 rows) and when i select Negative then it has to show 1 row and 3 rd row of data. I have written the following filter at report level "-Analysis"."Balance - units" < case when '@{PV_Negative}{ALL}'…

Hi, I want to understand that is it based on data model in BMM layer, the record limit will be set. Regards, Chandra.

Please confirm do i need to count hidden columns also.

Hi, Configure means...In the connection pool setting i have given DB user credentials and in the Write Back Tab it shows as shown below attached. Regards, Chandra.

Hi, 1. check your user has rights - YES 2. check the connection pool can writeback - HOW TO CHECK THIS? 3. check the insert in the associated file against the db to ensure the syntax is valid - I have used UPDATE statement in write back xml file. I have tested update statement in oracle database. It's updating properly. 4.…

Hi all, The requirement is like this: Initially my report should display all the records. My dashboard prompt is have only Yes value as shown below. As when user selects 'yes' then my report should filter based on the condition (Supply date < Ship date). My report should display records Supply date < ship date. For this i…

Hi All, For the column "Supply Date" i have added filter and converted to SQL, written the formula like this "Supply Date" < "Ship Date" and '@{PV_Supply}{Yes}'='Yes' but without selecting dashboard prompt value to 'Yes', the report is filtering data ("Supply Date" < "Ship Date"). Please correct me. regards, ram.

Hi Asim, I have created a variable prompt with ALL and Negative custom values. In my measure column formula, i have written the following formula. case when '@{PV_Negative}{ALL}' ='ALL' then "- Inventory"."Projected balance" when '@{PV_Negative}{Negative}' ='Negative' then ??? (HERE I HAVE TO SHOW NEGATIVE VALUES ONLY from…

Working on reports (BICS) in Procurement module in cloud env.

Hi All, Any help is most appreciated. Regards, Chandra.

As shown below it is played the value BPA-TAW-3. i have clicked on BPA-TAW-3 value in source report. Regards, Chandra.

Hi Asim, Value is setting now. Now i clicked on "BPA-TAW-3" value, My target prompt is displaying the value. result: Thanks a lot. I just want to understand from you the concept behind this. Please explain Regards, Chandra

Hi asim, Created new report with source agreement column. Placed this report in dashboad page1 (Source Details) and prompt. Source agreement column has navigation link to target report. I have kept only one column in the target report and column name is: Agreement number. onclick on the value in the source report. then…

HI asim, I have selected BPA-TAWSEEL-10 value in the first prompt and clicked apply button. The prompt in the second dashboard prompt shows the value as selected in the first page prompt. Regards, Chandra.

Hi asim, 1st dashboard page has prompt. 2nd dashboard prompt has the same prompt as shown below. 3. Prompt Details: Now on click of report value from first dashboard page . The output from second dashboard page prompt value as follows: No change in the prompt. Regards, Chandra.

Hi asim, I have removed upper in first report and prompt in the first dashboard page. But target report output remains same. As asked i am attaching following screens. 1)first reports column formula for Source agreement 2)prompt column formula for source agreement The above report and prompt are in the first dashboard…

Hi Asim, In the second dashboard page which is on the same dashboard. I performed the following steps. 1. I have added same column prompt (Source Agreement column but name of the prompt changed to another) as in the first dashboard page. I have remove the apply button also. 2. I have added second report (target report). 3.…

Hi Asim, It's already defined as dashboard scope. Pls see the below screen shot. Regards, Chandra