Pretty much what the title says. Is it possible to show the MDX that is 开发者_JAVA百科sent to OLAP source when using a pivot table in Excel 2007?You can download the OLAP Pivot Table Extensions from
Dynamics AX comes with 25 predefined roles in the Default Analys开发者_JAVA技巧is Database. How do I create my own and associate this new Role with a Role within Dynamics AX?
I have been looking into PowerPivot and concluded that for \"self service BI\" and ahoc buidling of cubes it has its uses. In particular I like the enhanced UI that you get from using PowerPivot rathe
I have a star schema with Implicit Fact div开发者_StackOverflow社区ision as shown in Figure 5 at http://www.information-management.com/infodirect/20020308/4858-1.html?pg=2.
I have a table with several million rows. Each row represents a user session. There is a column called user which is not unique. There can be multiple sessions per user. I want to use Analysis service
I don\'t really know how to compose this question. My complay has been using Microsoft ProClarity for few years and we have a quite a few users using it publising books and doing ad-hoc analysis. With
I have installed the latest .net connector, I can add MySQL databases as Data Sources, I can even browse through the data from Busine开发者_C百科ss Intelligence Studio.
I have a fact table that has a column with dates loaded from an MS Access source. The thing is, some of the values are NULL and the SSAS won\'t let me refer开发者_运维知识库 my DATE dimension to it.
I\'m working with SQL Server Analysis Services for the first time and have the dilemma of working on a project in which users must be able to access SSAS Cubes (via a custom we开发者_StackOverflow中文
I\'m new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensi
加载中,请稍侯......