Questions tagged [data-cube]
56 questions
0
votes
0 answers
Dimensional Modelling: OLAP Operation on Data Cube
Assume that we have a data cube as follows:
DairyFarms = { , , }
Name = {Farm1, Farm2, Farm3, Farm4}
Time = {Jan, Feb, Mar , ..... , Dec}
Product = {Milk, Butter, Cheese, Yogurt}
Suppose I want to retrieve the…
Aditya Naidu
- 697
- 2
- 7
- 18
0
votes
1 answer
Plotting data cubes
Is there a way to plot data cubes with any kind of program? In order to plot this (1) image, I had to use TinkerCard, that by the way doesn't allow to put names along the data cube dimensions. Is there any kind of tool that allows do do something…
jackb
- 695
- 8
- 26
0
votes
1 answer
Assign Dimension value to SSIS variable
I have data cube hierarchy as follows.
I can access the highlighted node as
SELECT [Calendar].[Report Days].[All Members].[All].[WantInReport].[Yesterday].LastChild ON 0
I tried to run this query in Execute SQL task and assign the output to an…
udaya726
- 1,010
- 6
- 21
- 41
0
votes
1 answer
spatial mdx date aggregation function is not working with date like 01/01/2014
This is my mdx that is emitting error:
`with member [Measures].[incident_type] as '[incident].CurrentMember.Properties("incident_type")'
member [Measures].[incident_desc] as '[incident].CurrentMember.Properties("incident_desc")'
member…
Ranjeet Paswan
- 111
- 10
0
votes
1 answer
MDX constrained strtoset() with item list
We're developing a SSRS report using MDX. We need to filter by a list of items. We have a multiple items parameter based on a dataset lookup for our 'Intake' dimension. We've followed an MSDN page…
Jansky
- 1,455
- 1
- 17
- 33
0
votes
1 answer
Period based graph with age blocks using SSAS
I am just starting to use SSAS and I'm trying to produce a data cube that allows me to produce a chart of the number of people in a particular age range per quarter spanning a number of years. So for example:
| $ @$ …
Anupheaus
- 3,383
- 2
- 24
- 30
0
votes
1 answer
Implementing Date Range in OLAP systems
Please bear with me if this is a trivial question,I am a new bee
I am in the design phase of a OLAP system where i need to show cost for a date range.
I have three other dimension like product,vendor and language.
Should I add date as one more…
Crypt
- 189
- 1
- 4
- 13
0
votes
1 answer
Difference between Birt data cubes vs mondrian pentaho data cubes
I have used Eclipse birt data cube but didn't gain any performance improvement over a huge data. Could i get any performance improvement if i use mondrian data cubes.
What is the main difference between Eclipse birt data cube and mondrian data…
Krishna
- 438
- 5
- 18
0
votes
1 answer
Proclarity View Seems to be Out of Synch With the Associated Data Cube
My boss just handed me a task that neither he nor I have any experience in, nor do we have any strategies on how to approach it. The problem involves Proclarity and a Data Cube, neither of which are familiar to me at all. I'll do my best to provide…
T1M0THY
- 1
- 1
0
votes
1 answer
Expand and collapse (drilling) in cross tab BIRT
I have implemented a data cube that shows the population in each year(rows). The top grouping is on the continent and the next level of grouping is continents. I would like to place a + symbol against each continent, when clicked breaks the…
Nandish A
- 1,645
- 5
- 26
- 41
-1
votes
1 answer
multidimensional rdf datacube and google refine
I am trying to convert some multidimensional databases (3 columns-dimensions, 1 column value) to RDF datacube using google refine. Because I have some problems with the modeling, is there any good example (or some ready RDFs with that structure)…
