tags:

views:

2

answers:

0

Hi all,

I've got two questions about the Oracle Analytic Workspace Manager (10.2):

1. Cube does not show floating point values: We have a custom, non-materialized view with average rating values saved as decimal/float type. After creating our cube with aggregation rule 'Average' and cube type 'Decimal' the resulting output seems to cut off the decimal places and only presents the integer. How can we fix our cube to properly show the floats?

2. Default cube viewer layout: Is it possible to pre-define a viewer layout, so that we do not need to drag-and-drop the dimensions to get our desired layout?

Thanks for help!