empty values font family wont change from default

deahayes

Hi all,

I have been given the task to change the font family of a report BI Answers report to Arial, I was able to successfully do this except for where the values of a field are empty . Particularly for  Grand total option I set format values to Arial, however when export to Excel the blank fields are Calbri, how can I change this on the report without changing the main stylesheet.

Edit dashboard, edit analysis, Results tab, edit table view, column and measures - total after, format labels and format values- set to Arial .

Gianni Ceresa

deahayes wrote:a report BI Answers

An "analysis", a report would be a BI Publisher report, in Answer it's an analysis.

deahayes wrote:...except for where the values of a field are empty . Particularly for Grand total option I set format values to Arial, however when export to Excel the blank fields are Calbri...

Sorry but ... if it the cell is empty why do you care about the font? An empty cell in Arial looks the same as an empty cell in Calibri.

And by the way: calibri isn't set by OBIEE, it's the default font of your Excel, and OBIEE can't set a font of something which doesn't exist ("nothing" is different than NULL or "").

You can change any stylesheet I don't guess it will change that point. But if you set your Excel to use Arial as default font you will get what you want as it's not really an OBIEE in a way ...

deahayes

Thanks for the clarification,

When the user exports the analysis, they may make changes, they may add a date or value in the blank columns, etc so would like to have consistent font style on entire document. I did go to Excel Options, General tab and change create new workbook to Arial but did not fix my issue, empty columns are still coming up Calibri. Plus, I only need the Arial font on specific analyses not all.

Thomas Dodds

That's a data governance issue ... users making changes after the fact (why spend the money on a modeling tool like OBIEE?  just dump data sets via queries straight to Excel).

[Deleted User]

Thomas has it right. What's the point of pretending to do any kind of curated and managed analytics when things get exported into Excel and then manipulated?

What about governance? What about compliance? What about data protection rules? What about traceability?

If your employer / client / whatever wants Excel then do things in Excel but don't start bothering curated, rule-based systems with Excel requirements.

Gianni Ceresa

I can only agree with Thomas first and Christian after.

Now for your need you are maybe ignoring the best tool for the job: SmartView

Instead of trying to change an export from OBIEE in a kind of Excel format, bring the data directly into Excel so that the format (font etc.) is managed in Excel itself directly and OBIEE just give you numbers.