should I use OLAP or OLTP for reporting tools like BIRT, Jasper Rep开发者_Python百科ort... ? I want to build ad - hoc many documents (e.g. 1000000).Just to extend on icCube\'s comment and provide an a
I\'m looking for a sample on开发者_如何转开发 how to expose an olap cube as an odata feed so it can be consumed by powerpivot. I do not want to provide direct access to the cube.
A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student en
I have a pretty simple scenario but a very large data set (using even simpler example below to illustrate my issue).
I want to ask what are the performance gains of pulling reports in Sharepoint 2010 directly from an Oracle DW using an ODBC Connection as opposed to building an OLAP Layer using SSAS and accessing th开
I believe there are three layers to build up- 1) Presentation Layer/Data Visualization Layer 2) Constucting olap server(like mondrian) to access mysql database and produce results.
I\'m new to SSAS (this is my first project that involves ssas). I have a regular a SQL Server 2005 server (say Blah) that run database instance and sql server analysis service. I want to synchronize
does anybody know if SAP BW supports UPDATE CUBE statement in MDX query (connection to serve开发者_运维技巧r established via XMLA) ?? It returns some generic error and I cannot find any documentation.
Can anyone give me general guidelines on how to approach multi dimensional reporting where I\'d like to support at the very least cube generated f开发者_如何学Gorom Oracle and SQL Server databases. I
I\'ve just been watching the QCON presentation about Disruptor. It looks like (and it may well be I\'ve not fully grasped it - so SIA) this is good for OLTP, but I am not sure whether it is also usefu