I am getting an pop"there is no data to retrieve" when ever
there is no data in the DB,what should be done not to get
this pop up even if there is no data
Answers were Sorted based on User's Feedback
Answer / thejaswi
There is no such direct option to set up , but we can add another data provider with some dummy objects such as current datetime which will always return a value.Combine ur data provider with this dummy object data provider so that if there is no data from ur data provider this dummy provider results data and thus can eliminate this pop up.
Is This Answer Correct ? | 1 Yes | 0 No |
I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers
Report have 10000 records,how to restrict the end user to 1000 Records?
5.what is slowly changing dimension ?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
what is Scope of Analysis
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
how will you move the universe/report from development to production?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
how to do scheduling in desktop intelligence in BO XI R2
What is the size of data base?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?