GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING
REPORTS?
Answer / bhanu prakash
THE MOST COMMON PROBLEM IS JOIN PATH PROBLEM
i.e,
LOOPS
CHASAM TRAPS
FAN TRAPS
Is This Answer Correct ? | 2 Yes | 11 No |
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
Have you worked with multiple data sources? If yes. How do you link them?
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
What is the difference between condition & filter?
1.what is context? How u create? With example.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
how to find the size of the report
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
How will solve a loop caused by lookup table without using alias?
What is the difference between derived table and views? which one gives better performance?