tag:blogger.com,1999:blog-3303178385491249894.post3342432455947124637..comments2024-03-11T12:40:19.889+00:00Comments on BI Direct: Oracle Exalytics – Consistency Checking or/and Model CheckerPravin Khadakkarhttp://www.blogger.com/profile/00951643834171565870noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3303178385491249894.post-74482274592066259662015-08-26T03:09:36.590+00:002015-08-26T03:09:36.590+00:00i am getting this error .. Logical column "Co...i am getting this error .. Logical column "Core"."Dim - Date Retail Fiscal Calendar"."Fiscal Period Wid" is variable-based.<br />The primary level key of "Core"."Date Retail Fiscal Calendar"."Fiscal Period" has an invalid column for Aggregate Persistence: "Core"."Dim - Date Retail Fiscal Calendar"."Fiscal Period Wid".<br />[nQSError: 84058] The level "Core"."Date Retail Fiscal Calendar"."Fiscal Period" is invalid for Aggregate Persistence.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3303178385491249894.post-23390881155661923732014-10-12T11:17:20.614+00:002014-10-12T11:17:20.614+00:00Hi Pravin
Thank you for this post, it has been ve...Hi Pravin<br /><br />Thank you for this post, it has been very helpful. I'm running into Error B. I unfortunately don't have an option to remove duplicate rows from the data source. Could I use the data warehouse surrogate key instead of the natural key (which has duplicates in the data warehouse)? Or will it cause the aggregates to fail or be suboptimal?<br /><br />Thank you<br />JAnonymousnoreply@blogger.com