olap
How would you go about an OLAP dimension with a variable depth hierarchy?
In most cases, each level of a hierarchy withi开发者_Go百科n a dimension represents different concepts (i.e. country->region->city, year->month->day) and this is simple enough to use in a cube.[详细]
2022-12-30 06:34 分类:问答Star schema [fact 1:n dimension]...how?
I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema:[详细]
2022-12-29 05:14 分类:问答MDX Selective Summation for a Normalization Problem
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[详细]
2022-12-28 05:50 分类:问答how create and query a cube olap
how can I create a cube olap with oracle, how load the data from sources tou the dimentions and the fact table in the cube[详细]
2022-12-28 03:53 分类:问答MS Analysis Services OLAP API for Python [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this[详细]
2022-12-27 16:27 分类:问答Calculated Measure using dimension
I am trying to build a calculated measure in SSAS that incorporates a dimension parameter. I have two facts: Members & Orders and one Dimension: Date. Members represents all the unique members on[详细]
2022-12-26 22:13 分类:问答Denormalization database
I was taking a look at Star Schema Benchmark and then I was thinking is it possible to denormalize all tables from t开发者_运维知识库he SSB?[详细]
2022-12-26 11:10 分类:问答In SQL Server Business Intelligence, why would I create a report model from an OLAP cube?
In Business Intelligence Developer Studio, I\'m wondering why one would want to create a report model from an OLAP cube.开发者_如何转开发[详细]
2022-12-25 15:07 分类:问答How can I obtain a list of a SSAS Cube's dimentions and dimentions' attributes
I have a user asking me to list the dimensions and dimension attributes of our SSAS cube. I susspect I could generate this via AMO, but I\'m开发者_C百科 wondering if there\'s an MDX query or SSMS op[详细]
2022-12-25 12:48 分类:问答How to create a custom ADO Multi Dimensional Catalog with no database
Does anyone know of an example of how to dynamically define and build ADO MD (ActiveX Data Objects Multidimensional) catalogs and cube definitions with a set of data other than a database?[详细]
2022-12-24 18:17 分类:问答