[10.2.2] "TOTAL" CAFE FP6 issue

Post Reply
hittony
Posts: 70
Joined: Mon Apr 27, 2015 8:54 am
OLAP Product: TM1
Version: 10.2.2 FP6
Excel Version: 2010

[10.2.2] "TOTAL" CAFE FP6 issue

Post by hittony » Mon Dec 05, 2016 6:26 am

Hi all,

We discovered an issue after our CAFE was upgraded from FP2 to FP6.

A report has a dummy line which has 2 dimensions, entity and product. Empty and "TOTAL" are two values in this line. With FP2, we didn't have any problem, however with FP6, we got a refresh error.

The debugging process is as following:
  1. Change product value from "TOTAL" to "TEST", refresh was successful;
  2. Change entity value from Empty to "TOTAL", refresh was successful;
  3. In product dimension, there's no member which is named after "TOTAL", but there's another whose name begins with "Total";
  4. In entity dimension there's a member whose name begins with "Sales";
  5. Change entity value from "TOTAL" to "SALES", refresh was successful;
  6. Change back product value from "TEST" to "TOTAL", refresh was failed.
The error logged is InvalidMDXExpression: Error forming tuple expression (rte 399)

Thanks for enlightening us for further steps.

Cheers

Post Reply