Styjun

Poisson distribution: why does time between events follow an exponential distribution?

Does Peach's float negate shorthop knockback multipliers?

How certain is a caster of when their spell will end?

Accidentally cashed a check twice

Why is c4 bad when playing the London against a King's Indian?

Is the capacitor drawn or wired wrongly?

What flavor of zksnark in tezos

Count down from 0 to 5 seconds and repeat

Pronoun introduced before its antecedent

X-shaped crossword

What are the words for people who cause trouble believing they know better?

Replace only 2nd, 3rd, nth...character and onwards

Why is Colorado so different politically from nearby states?

What does War Machine's "Canopy! Canopy!" line mean in "Avengers: Endgame"?

Old black and white movie: glowing black rocks slowly turn you into stone upon touch

Can a magnetic field of an object be stronger than its gravity?

1980s (or earlier) book where people live a long time but they have short memories

Building a road to escape Earth's gravity by making a pyramid on Antartica

How were concentration and extermination camp guards recruited?

Working in the USA for living expenses only; allowed on VWP?

How to split a string in two substrings of same length using bash?

Responsibility for visa checking

Why is the relationship between frequency and pitch exponential?

My coworkers think I had a long honeymoon. Actually I was diagnosed with cancer. How do I talk about it?

How to exclude rows having data in all the columns

Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)Oracle - combining multiple rows to columns via left joinHow to sort null values with pivot.jsstatic column name in pivot tableEfficiently convert rows to columns in sql serverSQL Transpose rows to columns (group by key variable)?Use ON NULL with create table from pivot result (in oracle)Complex SQL Server Pivot Involving Null and blank vs. Filled valuesOBIEE Analysis Putting Value in a Blank columnOracle APEX Interactive Report Pivot on NULL value

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I want to include the rows that does not contain any column values for OBIEE resultset (pivot table) and exclude the rows that contain all the column values.

For Eg:

 Sales

 Day 1 Day 2 Day3 
Product1 200 150 100
Product2 125 NULL 120
Product3 NULL 75 220
Product4 NULL NULL NULL 

In the result set I do not want the first row to be displayed as it has sales count for all the three days but the rows for Product2,Product3 and Product4 needs to be displayed.

Refer to image here

pivot report obiee

share|improve this question

edited Mar 31 at 5:44

Tessy

asked Mar 24 at 13:08

TessyTessy

33

add a comment | 

0

I want to include the rows that does not contain any column values for OBIEE resultset (pivot table) and exclude the rows that contain all the column values.

For Eg:

 Sales

 Day 1 Day 2 Day3 
Product1 200 150 100
Product2 125 NULL 120
Product3 NULL 75 220
Product4 NULL NULL NULL 

In the result set I do not want the first row to be displayed as it has sales count for all the three days but the rows for Product2,Product3 and Product4 needs to be displayed.

Refer to image here

pivot report obiee

share|improve this question

edited Mar 31 at 5:44

Tessy

asked Mar 24 at 13:08

TessyTessy

33

add a comment | 

I want to include the rows that does not contain any column values for OBIEE resultset (pivot table) and exclude the rows that contain all the column values.

For Eg:

 Sales

 Day 1 Day 2 Day3 
Product1 200 150 100
Product2 125 NULL 120
Product3 NULL 75 220
Product4 NULL NULL NULL 

In the result set I do not want the first row to be displayed as it has sales count for all the three days but the rows for Product2,Product3 and Product4 needs to be displayed.

Refer to image here

pivot report obiee

share|improve this question

edited Mar 31 at 5:44

Tessy

asked Mar 24 at 13:08

TessyTessy

33

 Sales

 Day 1 Day 2 Day3 
Product1 200 150 100
Product2 125 NULL 120
Product3 NULL 75 220
Product4 NULL NULL NULL 

share|improve this question

edited Mar 31 at 5:44

Tessy

asked Mar 24 at 13:08

TessyTessy

33

share|improve this question

edited Mar 31 at 5:44

Tessy

asked Mar 24 at 13:08

TessyTessy

33

asked Mar 24 at 13:08

TessyTessy

33

asked Mar 24 at 13:08

TessyTessy

33