What is #DATASYNC error how to remove it?
Answer Posted / sunnyodc
This error come when you fetch more than 1 dimensions from
2 joined queries.
if you are merging 2 queries , you can pull all objects of
1st query , but only one dimension object from 2nd query.
you can use merged object from 2nd query but not the other
ones,
if you want to show remaining objects of 2nd query make a
measure variable of each dimension. that means put them in
new variable and define that variable as measure.
now bring them on report. select table go to property click
the option > show rows with empty measure values.
| Is This Answer Correct ? | 44 Yes | 14 No |
Post New Answer View All Answers
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
explain in detail about type 3?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is difference between webi and infoview?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain when to use local filter and when to use global filter?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what task is 98% of the required work of a business analyst?
What is the difference between user and versatile user?
In banking domain how many Fact tables,Dimension table are present?
What Is Snow Flake Schema?
What is the difference in creating filters in designer and business objects?