The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
34 views

date dimension OLAP cube design

I have a sales reporting system with incoming data like this date,editionID,outletId,Measure1,Measure2 2013-01-01,2,532,11,24 etc... I am new to designing data cubes (for the pentaho BI suite) and ...
-1
votes
1answer
386 views

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

This error shows up when I try to connect to database string host:port/servicename.
1
vote
0answers
70 views

OLAP Advanced custom filters date

How do i filter, in a Mondrian MDX Query, just the FACTS that have ocurred in a Range of Months over last 3 years? I need to make it dynamic so i can use parameters latter, so i need the following: ...
1
vote
0answers
90 views

BI - Cube Concept and MDX Query Help

In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client. I need to create a Saiku report where i can show How many clients Joined in per year. I have ...
0
votes
2answers
113 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
1
vote
1answer
295 views

How do I get Pentaho Reporting/Kettle to produce PDF reports by business entity?

We use Kettle/PDI to handle usage records from legacy systems and feed them to an analysis database/DWH and also we report to our customers their activity and a backend commission report on a monthly ...
0
votes
1answer
322 views

How to perform ETL from RDBMS to Neo4j

I have a mature 50+ tables web application based on mySQL. In order to do some advanced data mining I want to use Neo4j and the goodnes of cypher. However I'm having a hard time migrating my data from ...
0
votes
0answers
58 views

Inserting Records - How to get next incremented PK for each insert

I'm using spoon to look for Devices that have several attributes that define its location, and then create a Cabinet in that location if one doesn't exist. Is there an operation that lets me get a ...