Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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.
-
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 that new column through the BMM an Presentation Layer When Flattened I want to add another…
-
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
-
Are you wanting Usage Tracking? Or what OAC objects are scheduled jobs?
-
Have you turned on Developer Mode and looked at the Query/MDX that is generated? When you imported the cube did you flatten the measures?
-
Only place i have seen changing custom header is within workbook. You can change color of header and add a very small logo
-
So… If I remove the space before and after equal sign it works
-
Interesting… We were able to copy the reference to Session Variable out of working into different Dataset and it Validated.
-
@Christian Berg-0racle - got lucky. I can get you in a zoom call to show you. First one was done by one of my colleagues and he nor I cannot replicate (my second screen cap) in different dataset. His first one actually works which is great.
-
Take a look at Data Actions. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/use-data-actions.html https://blogs.oracle.com/analytics/post/data-actions-at-work-part-1-analytics-link