I\'m new to mdx and have been trying to solve the following problem for about a day now. Any help would be appreciated:
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
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
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
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
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
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
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I\'ve a relational table (id, parentId, name) which I\'d like to convert to a flattened dimentional table
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,