olap-cube
How to make my SSAS cube production ready
I am developing a data warehouse + a data cube for a certain client using Microsoft technologies (SSIS, SSAS and SSRS). I have almost finished doing the data warehouse. I have created a data cube in S[详细]
2023-04-09 05:46 分类:问答How to get current row value in a WITH MEMBER calculation MDX?
I would like to calculate a Measure based o开发者_如何学Pythonn the current row. Problem is I can\'t find a way to get the current row in a WITH MEMBER part.[详细]
2023-03-26 20:35 分类:问答Get data from olap cube in c#?
What is the best solution t开发者_如何学编程o get data from an olap cube?I used Adomd .Net and MDX queries.Yes you can use .Net and MDX. Just have a class with a list of variables and store data in an[详细]
2023-03-23 23:43 分类:问答Custom field not not going into the analysis services db
Using the process edi开发者_运维问答tor, I created a new field, Product (Reportable = \'Dimention\').[详细]
2023-03-23 14:28 分类:问答define measure aggregate at run time
Am using OLAP a开发者_运维百科nd i want to make measure functions e.g(count,max,..) to be selected by the user (to be as a filter).[详细]
2023-03-19 20:21 分类:问答SSAS modify server time dimension
I have a cube wich has the tipical server time dimes开发者_如何学Cion (it\'s stored in the OLAP server, not on normal SQL server)... It has some members like month, year, 10 days,... but I want to add[详细]
2023-03-16 02:00 分类:问答SSAS Compiling Data Before Processing Into Cube
Working on my first SSAS project from scratch and hoping for some guidance. I have seen different approaches to bringing data into a cube and wondering which is the preferred if any.开发者_C百科[详细]
2023-03-15 15:31 分类:问答Implementing data cube in c#
I am trying to implement a multi dimensional data cube in c#. Could somebody point in the direction of resources that would serve as a starting poi开发者_如何学Pythonnt. I am primarily interested in d[详细]
2023-03-10 19:12 分类:问答Multi-dimensional data processing alternatives
I am looking for a multi-dimensional data processing but without having to use any OLAP. For example, I have a table of sales transactions. I would like to have the total sales on many dimensions like[详细]
2023-03-01 05:51 分类:问答How to create a calculated member based on two measures and the hierarchy level of the queried dimension's current member?
I have a cube which has two measure members: [Measures].[Value] (integer) and [Measures].[EffectiveBelowLevel] (integer).[详细]
2023-02-21 21:56 分类:问答