I HAVE DRAGGED OBJECTS IN QUERY PANEL....
IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES
IN WHAT SITUATION IT WILL HAPPEN?
Answers were Sorted based on User's Feedback
Answer / sj
This Will happen when a context is in picture..if you have
selected objects from a table on which context is defined..
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / sh
When the 2 objects that are dragged belongs to 2 different context, then the SQL will show as Synchronization. This is not of a major concern. The Sync will ahve two queries which run independently and the results are then merged. This gives correct data
Is This Answer Correct ? | 7 Yes | 0 No |
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest
what is the difference between bo and cognos?
how many times can use the union operator in a report?
How toconnect one to one report?
what is crosstab reporting,slice and dise and drill mode??
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
How we drill up week to month?
1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
What is the pragma?