Hello everyone,
I appreciate your time in answering my question in advance.
I am currently using the Oracle BI Administration Tool version 12.2.1.4.0 to upload databases to my Oracle Analytics Server.
My question is: I am not able to generate an AGO function on my Analytics Server. The problem is probably on the OBIEE side, but I checked the consistency and everything seems fine. I have one logical table set in the business layer combining 3 different tables: one for year, another for month, and another for day. Everything seems fine. The chronological key is set at the date level, and I have set the logical level on the fact table as the date level. Why isn't it working? Could it be because I combined 3 different tables, and a dimension table should only be one table?
I can provide more screenshots if needed.
I do not want to create a measure at the repository level so it won't overload the dashboard.
