on 04-11-2014 3:27 PM
I am woundring how to setup css class and code like in this tutorial.
myalerting.css ?
Set up display properties for a crosstab: Design Studio 1.2 - YouTube.
if you have sample file please share I am sure other can be befits from as well.
I would like to use color display on numbers or icons in seperate column if the value in certain range or a value is below or avove business needs.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What you are looking is Conditional Formatting .
You need to set up conditional formatting at SAP BI BEx Query level .
Please Check the link below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think I was not clear on this.
I already have condition defined in bex. What I am looking for script and css code which can help me to either change the color on data in cell as per my defined conditions or show color icons such as Yellom Green or Red. As it shows in the link I have provided in post.
Kevin,
I could not get this to work on my installation; perhaps you can review and "run with it" or someone better with CSS can assist.
The gist of it is there is a class .sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert1Background to define the status symbol for the alerts
Based on your Exceptions in the BEx query, Good 1 is .sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert1Background
Good 2 is .sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert3Background
etc... Bad 3 (red symbol) is .sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert9Background
I tried the following custom CSS on the crosstab, note using IE (which now we can no longer use until Microsoft patches)
myAlerting.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlternating{
background-color:#F9F9F9 !important;
}
myAlerting.sapzencrosstab-DataCellDefault{
background-color:#FFFFFF !important;
}
myAlerting.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert1Background
{
color:rgba(0,0,0,0.0);
background-image: url('/aad/resources/~1398612272195~/sap/zen/crosstab/themes/sap_platinum/img/exceptions/status_1.gif') !important;
background-repeat:no-repeat !important;
background-position:center top !important;
}
myAlerting.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert2Background
{
color:rgba(0,0,0,0.0);
background-image: url('/aad/resources/~1398612272195~/sap/zen/crosstab/themes/sap_platinum/img/exceptions/status_2.gif') !important;
background-repeat:no-repeat !important;
background-position:center top !important;
}
myAlerting.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert3Background
{
color:rgba(0,0,0,0.0);
background-image:url('green.png');
background-repeat:no-repeat !important;
background-position:center top !important;
}
myAlerting.sapzencrosstab-DataCellDefault.sapzencrosstab-DataCellAlert9StatusSymbol
{
color:rgba(0,0,0,0.0);
background-image: url('aad/resources/~1398612272195~/sap/zen/crosstab/themes/sap_platinum/img/exceptions/status_9.gif') !important;
background-repeat:no-repeat !important;
background-position:center top !important;
}
I didn't want to hold you up and for sure I hope there is someone in the community who could help. I'll try again when we can use IE
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.