I'm hitting a wall in what I think should be an easy problem. I'm modeling a pretty simple schema in FM. In one "database view" namespace, I'm bringing in a few database tables. No alterations there. Then in a "business view," I have model query subjects that draw their data from the database tables, as well as making a couple of derived columns, and also specifying relations. The last is a DMR view which is a simple dimensional star-schema based on the query subjects in the business view.
One column I'd like to derive is a basic duration, which is the difference of two timestamp fields from the database table. The definition I have looks like:
[Database View].[tickets].[RESPONDED] - [Database View].[tickets].[SUBMITTED]
FM correctly recognizes this as a time interval data type, and when I make this element a measure in the DMR view, it still comes through as a time interval data type automatically. Tests work and the model validates.
The problem (finally) occurs when I try using this package in something like Analysis studio. If I bring in this measure, I get the following error:
RSV-SRV-0040 An application error has occurred. Contact your Administrator.
With the following details:
CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(FALSE, "FormatInterval() RSVariant argument is bad!");
RSV-SRV-0042 Trace back:
RSReportService.cpp(802): CCLAssertError: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(241): CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(774): CCLAssertError: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(211): CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::run(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(824): CCLAssertError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysisSpecification_Request
PPSAnalysis.cpp(169): CCLAssertError: CCL_RETHROW: PPSAnalysis::executeAnalysis
PPSAnalysis.cpp(161): CCLAssertError: CCL_CAUGHT: PPSAnalysis::executeAnalysis
core/RequestContext.cpp(537): CCLAssertError: CCL_RETHROW: RequestContext::handleRequest
core/RequestContext.cpp(534): CCLAssertError: CCL_CAUGHT: RequestContext::handleRequest
RSDataFormatService/RSFormatter.cpp(217): CCLAssertError: CCL_THROW:
The first item in the details seems concerning (CCL_ASSERT_NAMED(FALSE, "FormatInterval() RSVariant argument is bad!");), but how can I actually track down the bad argument? Any help is appreciated!
I'll add that I can use the measure in Query Studio.
I know this topic is quite old but still...
We also acknowledge this cognos error which occurs while working with intervals.
when intervals go over 600 hours or 25 days, this error shows...
Now, we also use this formula for callcenter reporting. And we certainly would like to see this error solved.
Any ideas? I already tried a lot but I probably could try more... :)