This content has been marked as final. Show 7 replies
Can you share more details about formula used and basic info about sum of sales without YTD
I Am useing This Formula in BMM Layer.
ToDate("Core"."Fact - CRM - Service Request"."# of SRs" , "Core"."Comparison Date"."Year" )
That is wrong, the syntax is
ToDate(column , level )
so in your case something like below
ToDate("Core"."Fact - CRM - Service Request"."# of SRs" , 1 )
Pls mark correct/helpful
I use your Synatax Getting Error in BMM layer
ToDate("Core"."Fact - CRM - Service Request"."# of Open SRs" ,1)
Error Like this..
[nQSError: 27002] Near <1>: Syntax error [nQSError: 26012] .
Level Means Level in the Time Dime.
I was wrong.
Make sure your dimension is Time dimension(check dimension general prop to check this), that would allow you to choose level in expression builder.
Looks like you are not using level and using just column.
Pls mark if helps
No I was Useing Time Dimens Only.When I selecting In Level it Will Showing Time Dimens Hierarchy.
can you share NQQuery.log message for the same. Make sure you have proper loglevel to see that.