Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Could you do it via the Parameter feature? Then Use it in the title of your Vis
-
You cannot calculate across rows. why can you not do as columns? How is logic different for CEO and Emp Co ?
-
you cannot calculate across rows.
-
Do you have nightly snapshots?
-
In Calculations you can CAST to a different data type. Or you could create an aggregation…Count(Contract Number)
-
OAC can connect to EPM FreeForm either directly or via semantic model, it is different connector from the Essbase connector. In order to use PowerBI on EPM FreeForm data you would create a subject area within the semantic model then connect PowerBI to that subject area. Be aware it will be very labor intensive to create…
-
Take a look at the Rest API commands https://docs.oracle.com/en/middleware/bi/analytics-server/oap_rest_api/op-v1-reports-reportpath-run-post.html
-
Connect Directly either via semantic model or the direct connector
-
Without seeing your workbook and reviewing logs I am not able to help any further. I would suggest looking at the Developer tab and looking at the physical query that is being generated.
-
Remove the Account Name Filter. Drag Hierarchy to Filter and use Selection Steps. You might need to enable it in advanced settings
-
Just like you would do a Smart View retrieve, you need to create a Point of View (POV). Every dimension needs to either be a row, column or filter. If you have a SME that provided a Smart View retrieve, try to replicate in OAC
-
You need to essentially build the POV via Filters. You will also need to change properties on filters to not limit values based on other dimensions
-
@Santhosh_N Please show me the list of dimensions and the filter bar.
-
When you work with EPM Data in OAC you need to set filters for all dimensions or have on pivot, like you would with POV in Smart View.
-
https://community.oracle.com/products/oracleanalytics/discussion/comment/66158#Comment_66158 Refresh metadata is messy and may mess up your subject area. it will also reimport and substitution variables. If you flattened the Account Dimension, you could manually add the new column in within the Physical Layer, then drag…
-
SR # 4-0000653172
-
@Bret I started to create SR and this came up as related. is that bug still open?
-
@Gianni - OAC @Bret - I will open SR
-
Bring in the Vendor Default with the Vendor Hierarchy
-
You could also use the following to switch views https://www.youtube.com/watch?v=0ibczIOKKOY