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

 BEST PYSPARK LEARNING SITES https://www.youtube.com/watch?v=s3B8HXLlLTM&list=PL2IsFZBGM_IHCl9zhRVC1EXTomkEp_1zm&index=5 https://www...