Stack Overflow
Stack Overflow

Questions tagged [measures]

58 questions
0
votes
1 answer

xmla / mdx script to define measure display folder

I have an SSAS DB that was automatically generated by an application i use. This DB has a lot of measures and I would like to define 'display folder' to the measures so the cube will be more user friendly in Excel. I want an xmla/mdx ( script that…
Eldad Meir
  • 1
  • 3
0
votes
0 answers

Cube: Passing one dimension current member inside the argument of another dimension

In OLAP cube, while creating calculated measures, is it possible to pass the current member of one dimension (say [Dimension_Two]) as a parameter of Lead() or Lag() functions for another dimension ([Dimension_One])? Something like this: Sum(…
pso
  • 819
  • 12
  • 25
0
votes
1 answer

How to get TTFB (Time To First Byte) in Java using a HTTPURLConnection

We are working in a Tool that measures performance of web sites in a not intrusive way (not modifying the web site source code). We have a small application in Java that fires request over the internet to our customer web sites and save the…
Marcelo Dias
  • 409
  • 2
  • 18
0
votes
1 answer

Power Pivot Sum across factTables

I'm having trouble creating a sum across multiple factTables in Power Pivot for Excel 2010. Here's a simplified layout. Network A - Date, Product Name, Revenue Network B - Date, Product Name, Revenue Network C - Date, Revenue dimCalendar They…
Jiminie.Glick
  • 27
  • 1
  • 1
  • 5
0
votes
1 answer

Combining two calculated measures and using the combination result in MDX

I am creating two different calculated measure and I want to use the result of both calculated measure in one query from a same cube. One of the calculated measure created is - With Member [Measures].[VenueSalesCost] as ( [Measures].[Amount -…
Ayush Khanduri
  • 50
  • 8
0
votes
1 answer

OLAP cube in schema workbench measures shows no data

Iv'e created a simple Schema in Jaspersoft OLAP designer. Now i want to publish my Cube in a view on jasperreport Server. I managed to get this to work before with other Schemas but now i don't get any values out of my sum measures... Can anyone…
user2210516
  • 613
  • 3
  • 15
  • 32
0
votes
1 answer

Fitting repeated measures in R

Fitting repeated measures in R, convergence issues. I have the following fit which is one of many datasets and it doesn't converge. I do other sets that do. This dataset and model work in SAS... Could I get some direction in what to do to have this…
user2945234
  • 418
  • 6
  • 12
0
votes
1 answer

SSAS Processing tasks Optimization

I have 10 Dimensions and 10 MeasureGroups I tried to process a particular MeasureGroup(say MeasureGroup-1) and associated dimensions(Which i saw in a window while > Right click on cube > newQuery > MDX >Selected MeasureGroup-1 in dropdown list) in a…
user2889510
  • 11
  • 2
0
votes
0 answers

Clickstream measures at different granularities

This is possibly a simple problem which I have yet to overcome. Consider a cube based on clickstream data. First, I have a fact table based on page views. That is One Row per page view on a site. Measures includes [Views], [Visits], [Bounce Rate]…
Nick
  • 11
  • 1
0
votes
1 answer

Grouping SSAS measures

Hi I have a fact table in my cube with member visits to a building. There is an hour dimension on the fact table. For example: Member 1 visits 2 times between 1:00-2:00 Member 2 visits 2 times between 2:00-3:00 Member 1 visits 2 times between…
Chris
  • 163
  • 1
  • 1
  • 10
0
votes
1 answer

Measures as attributes when consuming data from a Power Pivot

I created a Power Pivot workbook that has information from our store (the plan is to connect to this document and consume the data), basically is something like this. CostumerID | QtyPurchasedProductA | QtyPurchasedProductB | QtyPurchasedProductC…
user1112251
  • 119
  • 1
  • 4
  • 13
-2
votes
1 answer

How to measure accuracy of image segmentation algorithm?

I want to know the possible measures that can be used to measure the accuracy of my image segmentation algorithm I know the following methods: sensitivity specificity Dice index Jaccard index But I am working with large data set that needs to be…
Ahmed Hassaan
  • 99
  • 1
  • 12
-6
votes
1 answer

Crime Data Warehouse

I am a IT student and now facing problem in understanding data warehousing. I need to implement a data warehouse that will be used in State police department for crime analysis. But I am not sure how to do with measure. I will use star schema. I…
Hashi
  • 3
  • 7
1 2 3
4