I was suprized to realize that some previous well functioning SSRS reports failed when 'previewed' .
The error sound like : "An error occurred during local report processing. An error has occurred during report processing.Query execution failed for dataset '****'. Parser: The syntax for 'Date' is incorrect.
But the report worked once and as far as I could see nothing has changed behind time. So how can it be ?
It took me a while to realize, that all of a sudden it does not like the parameter name 'Date' , because the syntax around it has never changed. It looked like parameter names like @Date and @Application were not allowed any more. They were treated as reserved keywords.
So the solution was just dummy replacing them - by @Date1 , @Application1 or the like - in query , parameter list and all the way around where they showed up.
Then I could preview the reports like I did it once.
If you also experienced this or have an idea of the root cause of this issue, please leave me a note.
fredag den 5. august 2011
Some parameter names not allowed in SSRS 2008 R2
torsdag den 4. august 2011
Cross selling by using data mining
Data mining is often an underestimated part when it comes to BI
I have uploaded a demo concerning cross selling in financial industry by using data mining: http://www.youtube.com/watch?v=RqHKOuQpdrY
Cube writeback with multiple values in one shot
Writeback ( writing to a cube) from a client application is not a trivial task to implement.
Writing multiple values in one shot can be tricky.
I made a video showing a SSAS cube writeback application with multiple values at a time: http://www.youtube.com/watch?v=HW9Jqya7OOQ
Abonner på:
Opslag (Atom)