Like we discussed in my other blog over D3 visualizations in Obiee 11g, we have another data visualization technique called “word clouds”, that is used to
graphically show word distributions in unstructured data sets through
font sizes and orientations. For example, the word cloud shown below display the company names in different sizes/fonts.
It can be implemented in OBIEE11g reports, without using any extra help. We just have to create a dummy column using any logic to get dummy values ranging between 5 to 70 and then in Narrative View we can use this column in font size of Company column.
for example: I created a dummy column C1 like (count Of Transaction) * 5) / Max (count Of Transaction). This will give me value range from 5 to 70 ( you can range your values depending on Font size required in Cloud).
Now in Narrative View, while displaying the Company name column, mention Style (font-size = @C1;) and its done.
Do try it.
It can be implemented in OBIEE11g reports, without using any extra help. We just have to create a dummy column using any logic to get dummy values ranging between 5 to 70 and then in Narrative View we can use this column in font size of Company column.
for example: I created a dummy column C1 like (count Of Transaction) * 5) / Max (count Of Transaction). This will give me value range from 5 to 70 ( you can range your values depending on Font size required in Cloud).
Now in Narrative View, while displaying the Company name column, mention Style (font-size = @C1;) and its done.
Do try it.
No comments:
Post a Comment
Please drop your valuable feedback !!