How to create an popup in the WEBI report if the report is showing partial result?
Answers were Sorted based on User's Feedback
Answer / nagendra hathwar
BY USING DocumentPartiallyRefreshed() function.
It returns true if document is partially refreshed else
returns false.
Cheers
Nagendra
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gowthami
enable the option to display the warning symbol in the properties tab. then the symbol will be displayed at the bottom left corner
| Is This Answer Correct ? | 0 Yes | 1 No |
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
how many micro cubes can a report can have
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?
what is universe null
How to Analyise 'Join' problem and which method is the best to resolve that ?
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
What is the profile and package?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)