Tuesday, December 2, 2014

How to get even odd records in analysis of OBIEE11g

How to get even odd records in analysis of OBIEE11g


Step 1:- First we need to create an analysis report
            add any extra column and click on Edit Formula

MOD(RCOUNT(1),2)

Click Ok and Save The report.
Then Filter in the particular column 

MOD(RCOUNT(1),2)=1
OR
MOD(RCOUNT(1),2)=2


Run the report and you will get in your wishes as even or odd





Thanks


No comments:

Post a Comment

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...