When using OAC DV in french, we need the "." as thousand separator instead of space

Indeed, we need that functionnality too. As a administrator, I need to check which dataset is used by which project for our users community. Perhaps may we find the answer via the BAR file ...

Using the time dimension does not work completely. I give you an example related to accounts with budgets. The user will use a period dashboard prompt to select some periods (e.g. 201701 to 201703). Then I want to display : - the account; - the amount for period 1; - the amount for period 2; - the amount for period 3; -…

But how could you explain that when I am applying a filter on employee number, I get the good results for the budget and the actuals ? I am wondering if the clause "FETCH FIRST 20000001 ROWS ONLY" in the logical SQL don't cause the problem ? Thx.

The employee numbers are ok in both databases. What is also strange, as you can see in the attachment here, is that I get different results when filtering or not filtering on an employee. When a filter is applied on an employee (here employee 4316), the results are correct. But when there is no filter applied, the results…

Here are in attachment the two measures with the content level which are all set to the detail level

So I have the following foreign keys in both transactions table : period, cost center and account. The results seems ok for those dimensions. For the employee dimension, I have the foreign key in the budget transaction table (Oracle database) but I need to join to another table (called BSEG) for the Sap Hana transaction…