Dear Yash
I am unable to find a way as such in Business Objects at the report level. But you can rewrite the first DP1 n such a way that the WHERE clause has a condition like stCde1 InList StCde.
Will this help ?
Regards
Tiji
I guess you can try insertng a filter on the table containing rows from the first dataprovider
Filter defintion : = StCde1 = StCde2
Hope this helps!!
Regards
Tiji
Dear All
In Business Objects, it is said that we can customize the external strategies by adding our SQL to the [STRATEGY] section of the stor7en.txt file.
I am aware that there are 3 types
1. OBJECT
2. JOIN
3. STRUC
I could not find a custom strategy for the TYPE=STRUC. Does anyone...
Hi Dave
Only OLTP Systems have privileges given to developers to run the procedueres. The use of Stored procedure or Functions have ben disabled with the rationale of managing such a large databse and avoiding tampering of data.
Thanks for you help Dave.
Regards
Tiji
Dear Dave
Appreciate your Co operation in this regard. Although the function perfectly fits into my requirement. The current Database does not allow one to run user defined function.
I guess I will have to manage with the application level function.
Thanks For your Help.
Best Regards...
I am working in Datawarehousing and the application (Business Objects) has thsi functinality to check if the input value is a valid date or not.
eg. Isnumber("12312") = True
and Isnumber("DJHSDJ") = False
Similarily, I am expecting a function
Isdate(" ") = False...
Dear all
Could any one tell me if there an inbuilt function to check the data type of an input quantity through ORACLE SQL Query. I am not verifying any datebase column data type. I am verifying a prompt variable data type based on which I need to output sysdate or a the selected date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.