olap
OLAP or ALTP at reporting Tools
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[详细]
2023-04-13 04:27 分类:问答Any sample on how to expose a olap cube as oData so it can be used using powerpivot?
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.[详细]
2023-04-12 11:57 分类:问答How to report on sparse areas of sparse fact table
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[详细]
2023-04-11 15:44 分类:问答Setting up a relative dimension?
I have a pretty simple scenario but a very large data set (using even simpler example below to illustrate my issue).[详细]
2023-04-08 00:04 分类:问答to OLAP or not to OLAP
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开[详细]
2023-04-07 20:41 分类:问答Please suggest ways to start building Business Analytics solutions using existing mysql databases
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.[详细]
2023-04-07 04:13 分类:问答SQL Server 2005 Analysis Service (SSAS) Partial Synchronization
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[详细]
2023-04-04 21:32 分类:问答Updating cube (writeback) via MDX on SAP
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.[详细]
2023-04-04 13:36 分类:问答Olap/multi dimensional reporting, WPF client, agnostic data?
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[详细]
2023-04-03 17:34 分类:问答Disruptor and OLAP
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[详细]
2023-04-03 14:05 分类:问答