how to restrict null values in webi report?
- 2 Answers
- 29162 Views
- InfoStep, I also Faced
- E-Mail Answers
Answer Posted / visu
I believe you can define a formula like below
Not IsNull(object). This formula should bypass all records
that has null values..There might be some other ways too..
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain which versions are used in the bo dashboard work?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain about a tricky situation for which you found a very simple solution?
Explain in detail about type 1?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
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
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain what task is 98% of the required work of a business analyst?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain about a time when you discovered a more efficient way to do a work task?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what is the difference b/w the refresh and buffered data?
