cancel
Showing results for 
Search instead for 
Did you mean: 

Display all dimension values

former_member224535
Participant
0 Kudos

Hi All,

I have created variable like below....

=If([Type]="A";"TypeA";If([Group]="B";"TypeB"))

Then below is the data displaying in crosstable

Group/TypeTypeATypeB
GA5102
GB846
GC3

When I use the filter... Type is not null then it is displaying

Group/TypeTypeATypeB
GA510
GB84

But i am expecting below data (all values should display eventhough respective KF's are null or 0)

Group/TypeTypeATypeB
GA510
GB84
GC

I already tried below work around options, but still no luck... 😞
- checked all the 'show' options in format table,
- Also tried with formula......if(isnull([KF]);0;[KF])
- Created query2 without KF and merged on 'Group'and then created new variable on merged object '[Group]'

Could you please help me if we have any work around to display all dimension values......

Note: Datasource is BEx query and webi4.1

Thank you,

Ranjith

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

which filter you are applying on table?

Thanks,

swapnil

former_member224535
Participant
0 Kudos

Hi Swapnil,

Applied filter on 'Type' object... (Type = Not null)

then it is not displaying Group 'GC' as it has no values for measure 'KF', but i am expecting this row with blank values.

As I mentioned I tried above three work around, but no luck.

Thank you again,

Former Member
0 Kudos

why do you apply filter on type then just apply it on KF!!

amitrathi239
Active Contributor
0 Kudos

Hi,

Create one new rule in webi  and condition will be Type is null

Under the Format select text colour is white and background colour white.

Select No border.

Format cell for both Type column and values column and select auto width & Height.

Amit

former_member224535
Participant
0 Kudos

Hi Amit,

I have applied that rule for both Type and KF... now type 'blank' column is displaying in white and  without border..it is fine

But since we have values for type 'blank', so width is not reducing for that blank column.

I am not sure how type 'blank' width is reduced in your screenshot..

Could you please give more details...

Thank you again,

Ranjith

amitrathi239
Active Contributor
0 Kudos

recheck the  auto width & height are applied on the type and KF columns.In the rule Format ->formula section put =""

if this will not  work then share the screenshot.

Amit