I have the following problem. In obiee when I create analysis from table A, its measure columns showing null, even though in database there are no null values in this table.
I used only this table and did not select any columns from other tables. Non-measure columns are fine though like client_id, client_name. However any calculated in rpd measure of that table shows null. What can be the reason?
Edit. Log has the following : The expression "measure_column" is converted to null because None of the fact tables are compatible with the query request
If you really have measure columns in your dimensions it's time to completely go over what was done in the RPD. it seems to have severe issues built in.