Skip to Content

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

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!

1.png (5.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 07, 2016 at 05:25 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08, 2016 at 12:27 AM

    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.

    Best regards

    Ingo Hilgefort, Visual BI

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.