...
Configure connection.
Cube
For Api Url use host url without any path e.g. https://epm-a111111a000000.epm.em2.oraclecloud.com
Application name is the same you see in oracle
For credentials use username combining domain + “.” + username
Example: for picture below username would be a000000.xxxxxxxxxxxxx
Configure dimension mappings. Most standard dimensions would be mapped already – you need to map custom ones. Number of custom Oracle Dimension doesn’t matter and only used on our side. You only need to fill in allias corresponding to custom dimension name.
...
Multiple members are supported and should be separated by comma
Don’t use quotes around members (even if they contain spaces)
Don’t use “@” before selector methods (like
@ChildrenILvl0Descendants(YearTotal))
Fill in Account dimension on Row and Period on Column
...