empty values font family wont change from default

Question

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 · Answer

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.

[Deleted User] · Answer

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.

Thomas Dodds · Answer

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).