cancel
Showing results for 
Search instead for 
Did you mean: 

Has anyone figured out conditional formatting of crosstabs based on a Universe?

0 Kudos

I've crawled through the posts and manuals and have spent a couple odf days now playing with CSS with zero luck on getting conditional formatting working on my cross tab. Seems like this should be an easy task in Design Studio but it's certainly not. Hoping someone out there has gotten this working and can help all the rest of us that are stuck on why ours won't work.

Here's where i am right now with my crosstab.

I've turned on Conditional Formatting as expected and i would think that this should be bound to the data to make it dynamic.
It's tied to my DS_2 datasource and i'm not sure why but i selected a data cell as the next property requires this. I'm guessing it's because DS needs to know what area of my table to conditionally format and here it would be the data cells.

I then defined a formatter function which to me makes no sense as it returns a boolean value rather than a string for a css style so all i did was create a simple if statement to check if a value was above 20 then return true otherwise false. From here i'm absolutely lost, there's no where to specify colors or tie them to more ranged thresholds or anything. Is this functionality for Bex only? If so it shouldnt be displayed when using UNX as a source. If its truly for all sources, then how do you use it with a Universe? Has anyone had any luck with this?

Thanks all for your help!

Accepted Solutions (1)

Accepted Solutions (1)

MustafaBensan
Active Contributor
0 Kudos

Hi Shane,

According to the Design Studio Application Designer Guide, the Crosstab Conditional Formatting Visible property is only applicable to BEx Queries or BusinessObjects Analysis Edition for Office.  This seems to imply that Universe data sources are not supported.

Regards,

Mustafa.

0 Kudos

Thanks Mustafa! Interesting considering the number of customers on Xcelsius and UNIX looking to migrate that this simple functionality wouldnt be there.

Former Member
0 Kudos

I was struggling for last couple of hours and decided to post in this forum until I saw this message.

Why the formatting has anything to do with data source? Waiting for CSS trick here.

Thanks

Ravi

Answers (1)

Answers (1)

IngoH
Active Contributor
0 Kudos

Hello Shane,

feel free to try out our extensions which does also provide a table component with advanced conditional formatting capabilities on any data source.

http://visualbi.com/sap-design-studio/dsx-extensions/

Best regards

Ingo Hilgefort, Visual BI