Long time no see, my dear diary!
Recently I have been working with Essbase and Interactive Reporting, which are one solution of Oracle to BI. Well, few problems appear in Essbase because this multidimensional database system is quite easy to use and all the rules files in those cubes involve simple logic of accessing data from Sybase IQ, which is our data warehouse. Except that, there are some bugs in Essbase 11.x. For example, when you edit the property of a member, and in the Formula dialog, even that you have written some MDX statements, you still cannot see them in the dialog. So how can you see these statements? The only way is to press Ctrl+A to select all of them, and then you can see them. Of course, it's not easy to edit your MDX statements! This bug happens when you open your MDX editor in Essbase and edit your MDX statements, too.
But those questions such as the above seem not to affect our work actually. However in Interactive Reporting, you will find this tool really hard to work with! Suppose now I have delevoped a report using IR, and all the dimensions and facts(we can also say columns) of the report are added dynamically; that means every time I press the "查询" button in the page, the dimensions and facts of the report would be al removed and some or all of them added again, and this is according to what the user's query requests. Now, I want to change the format of the title of the report. I open the software, and press "Tools" in the menu bar, then "Options", and then "Default Formats". In the dialog, I choose "Reports", with Report Table Haddings, what I set are as follows,
Font Name:宋体
Bold
Horizental:Center
Vertical: Middle
And unfortunately, it doesn't work. When I add a new column in my codes, the title of this column in the report doesn't change to what I set. And I don't know why!! The image is one of my bqys.