if i change it to serve complex aggregate,it throws an error i can only do 'sum'

yes,the number increases as i go down the hierechy in the rpd. i have 2 hierarchies defined for calendar and fiscal calendar on date logical table.do you think that would have any impact? let me know if we need to specify aggregation rule for a time series metric in analysis or will the tool use the aggregation on the base…

my date hierarchy looks like this Total ¬ Fiscal Year ¬ Fiscal Quarter ¬ Fiscal Month ¬ Detail And also MTD number gives me right number. I get error only when I add grand total on timeseries metrics

measures in rpd. aggregation is sum on weight metric and i used the same column to calculate MTD using TODATE function. i dont see "Default(Sum)" as aggregation rule option on MTD measure.

OBIEE VERSION: 12.2.1.0.0 i created below table showing weight and weight month to date (defined at fiscal month level) . Both metrics are showing same number as expected when i add grand total , i get below error unless i specify aggregation rule as sum for MTD metric in the analysis. Is this expected? in the aggregation…

i have created time series metrics and they are working fine,but when i put grand total on a table view,getting below error: [nQSError: 22036] Level in ToDate function (Fiscal Month) must be a rollup of (or equivalent to) the measure level (Fiscal Year) is this expected error or do I need to do anything different in the rpd