Questions tagged [measures]
58 questions
1
vote
2 answers
SSAS Cube Measures Incorrect
I am working on a project for work and both me and my boss are stumped. We have created a few SSAS cubes to work with views in our database. 6 in total. All seprate. The first 5 work just fine with all cubes being set up the same. The last one we…
Ian
- 63
- 7
1
vote
1 answer
Friedman (agricolae) error
I'm trying to run a blocked, repeated measures ANOVA with the friedman test (agricolae package). However, I keep getting the same error and I don't understand what it means.
This is the code:
out<-with(nh3,friedman(season,datecode,meannh3, alpha =…
Emily Cavaliere
- 41
- 8
1
vote
2 answers
tsql : Pivot a table with multiple measures
This is the first time I am trying to pivot a table. I have managed to pivot the table with only one measure and failed to do it with multiple measures. Please can I get some advice? Below is the test data I have and I would like to see. Please note…
ichange
- 11
- 3
1
vote
1 answer
Iccube: measure as a filter
Iccube - Reporting:
I would like to use certain values of measures as a filter.
For example:
dimension: product -
measure: price
I would like to filter all products which are < 50€.
A workaround would be a second dimension "price" but I dont want…
J.Doetwo
- 81
- 7
1
vote
0 answers
SSAS: Measure added to an existing working Measure Group not showing values
I added two measures to an existing measure group, the old measures work correctly, the new measures show 0.
I have tried the following:
Deleting and Redeploying the cube
Re-processing the partitions
Changed cube to Full Process
Changed a dimension…
Mike Lum
- 11
- 3
1
vote
0 answers
mlr assertion of measures failed
I am running 4 classifiers on a dataset and comparing their performance. When I run the following code I receive some weird errors:
library(mlbench)
library(mlr)
maxx_IL10 = c(3199, 2997, 2690, 2482, 2891, 2310, 3180, 3050, 3115,…
tom
- 315
- 1
- 3
- 10
1
vote
1 answer
SSAS - max over time for semi-additive measure
I'm pretty new to SSAS and MDX. I have a measure which is currently an average over time, for example # of employees stored by department. I understand this is considered semi-additive. Is there a way to keep this semi-additive, for example, sum…
Holdfast4
- 63
- 1
- 4
1
vote
1 answer
period of sawtooth from measurements
I have a series of 2D measurements (time on x-axis) that plot to a non-smooth (but pretty good) sawtooth wave. In an ideal world the data points would form a perfect sawtooth wave (with partial amplitude data points at either end). Is there a way of…
user46655
- 11
- 7
1
vote
2 answers
Does OData v4 understand Dimensions, Measures and Cubes
I am building an OData Web Service using WebAPI and OData v4.
I am wondering if this new version of OData is capable of understanding Dimension, Measures and Cubes and is able to execute Queries from the data.
How would I be able to configure that?
Francesco Ferraioli
- 96
- 1
- 5
1
vote
1 answer
Cognos 10 multi fact crosstab
I am making a cross tab that displays how many people of certain race and ethnic origin signed up for a program by county
So the rows are a list of each county and the columns are the races sub divided by ethnicity. …
Mohammad Zeni
- 13
- 1
- 1
- 3
1
vote
2 answers
MDX - Why Cross join between measures do not work?
In MDX, we can CROSS JOIN two members, a measure and a member but not two measures. Why is this so? What does it imply?
SELECT
[Measures].[xyz] * [DimTable1].[SomeHierarchy].[Level] on 0,
[DimTable2].[SomeOtherHierarchy].&[Value] on 1
FROM…
SouravA
- 5,147
- 2
- 24
- 49
1
vote
1 answer
Update Dimensions/Levels/Measures programmatically
Summary :I m involved in a project that requires us to update/upgrade a existing cube programmatically. Is this even possible (apart from using AMO)?
Details: We have a cube that deploys to all client environments via a installer. Now as we continue…
user3198708
- 37
- 1
- 9
1
vote
2 answers
Robust Measures of Algorithmic Trading - Based on Robert Pardo's Book
I am optimizing algorithmic strategies. In the process of choosing from a pool of many optimized strategies, I am in the phase of searching (evaluating) for robustness of the strategy.
Following the guidelines of Dr. Pardo's book "The Evaluation of…
1
vote
1 answer
Dimensions and MeasureGroups Prcessing
I have 10 dimensions and 10 measuregroups-- each measuregroup is having one partition each.
All the cube when processed it takes 5-6 hrs daily. so i thought to process the cube using SSIS analysis Services processing tasks where 1st i process…
user2889510
- 11
- 2
1
vote
1 answer
How to establish in a mdx query 2 measures and a hierarchy
I Have this query:
SELECT NON EMPTY {
[Art].[Art].[Art].ALLMEMBERS * [Measures].[Costs] * [Measures].[Margin]
} ON COLUMNS
FROM [Model]
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE,
FORMAT_STRING, FONT_NAME, FONT_SIZE,…
mekoloko
- 83
- 2
- 7