olap
MDX result categorisation
I\'m new to mdx and have been trying to solve the following problem for about a day now. Any help would be appreciated:[详细]
2023-01-25 03:11 分类:问答How to Print a Chart in Excel 2010 for every value of a Slicer?
Before I give a description of the problem, here is the list of technologies I am using - Excel 2010, PowerPivot Add-in, Win 7, Macros - VBA[详细]
2023-01-24 05:26 分类:问答Non-aggregated measure in OLAP cube
Is possible to add a non-aggregated measure to an OLAP cube? fo开发者_开发百科r example I have a \'Datetime\' field in my relational DB, and I would like to not use any kind of aggregation function wh[详细]
2023-01-24 03:08 分类:问答Adding a Relationship in olap Cube
Is possible to join a dimension to an OLAP cube using fields that do not开发者_C百科 have a foreign-key relationship in the underlying relational DB?Yes it is possible. It is called logical relationsh[详细]
2023-01-23 21:37 分类:问答Inheriting fields from a parent table olap cube
I have an OLAP cube containing a numeric measure that represe开发者_开发问答nt a foreign key against a parent table. I would like display the \'name\' field from the parent table instead of the measur[详细]
2023-01-23 11:22 分类:问答Varchar measure in Olap Cube
All the me开发者_如何学运维asures should be necessarily numerical? what about a varchar measure?You cannot have real varchar measures. You can however create a calculated measure that has some varchar[详细]
2023-01-23 10:44 分类:问答star schema for implementing near real time analytics with changing data
I implementing analytics for a medical software. The data to be processed is mainly appointment related. I\'m planing to implement star schema for generating reports. I have a few doubts[详细]
2023-01-23 06:58 分类:问答What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2023-01-22 13:18 分类:问答Transform a parent/child table to a fixed column dimentional table
I\'ve a relational table (id, parentId, name) which I\'d like to convert to a flattened dimentional table[详细]
2023-01-21 20:57 分类:问答Microsoft Analysis Services Translations
I have the following scenario: From .NET (v3.5, c#) I connect to an OLAP Cube using the Microsoft.AnalysisServices namespace and objects in order to manage dinamycally the translations of dimensions,[详细]
2023-01-21 20:28 分类:问答