US and Worldwide: +1 (866) 660-7555

# Search Forums:

Type: Posts; User: Heisenberg; Keyword(s):

1. ## Thread: Problems with Schema for Time-Dimension

by Heisenberg
Replies
3
Views
242

### Hi, of course it is a shared Dimension. I...

Hi,

of course it is a shared Dimension.
I changed the following things which made the cube work:

- I changed from DayOfMonth to DayOfWeek in the Year, Week, Day Dimension
- I deleted the...
2. ## Thread: Problems with Schema for Time-Dimension

by Heisenberg
Replies
3
Views
242

### Problems with Schema for Time-Dimension

Hi folks,

I used to work with a time-dimension which looks like this:

<Dimension type="TimeDimension" visible="true" highCardinality="false" name="DateTime">
<Hierarchy name="YMD"...
3. ## Thread: How to join two Stars

by Heisenberg
Replies
28
Views
606

### No! Sorry for the confusion. Pentaho (4.8)...

No! Sorry for the confusion. Pentaho (4.8) includes Mondrian 3.5.0 by default. See mcampell's post...
4. ## Thread: How to join two Stars

by Heisenberg
Replies
28
Views
606

### Actually I solved this problem once, far in the...

Actually I solved this problem once, far in the past by using a Virtual Cube I think.
But I just found this in the Book "Mondrian in Action":

So maybe "Measure Groups" is your and mine new...
5. ## Thread: How to join two Stars

by Heisenberg
Replies
28
Views
606

### Until yesterday I was sure that this is quite...

Until yesterday I was sure that this is quite simple by creating a Virtual-Cube (which contains all dimension and measures). But I have my problems with this requirement too (see my Thread...
6. ## Thread: Problems with Cross-Join

by Heisenberg
Replies
2
Views
216

### I can view FACT_A and FACT_B while using the...

I can view FACT_A and FACT_B while using the shared Dimensions (Time and Dimension1), but when I add a level from DIMENSION_B (or A), FACT_A (or B) returns no Data.
7. ## Thread: Problems with Cross-Join

by Heisenberg
Replies
2
Views
216

### Problems with Cross-Join

Hi folks,

I have defined a Schema which looks like this:

Time Dimension (Shared)
Dimension1 (Shared)
Cube A
8. ## Thread: ClassCastException while using CDA

by Heisenberg
Replies
2
Views
223

### So, big thanks go to pstoellberger from ##pentaho...

So, big thanks go to pstoellberger from ##pentaho IRC! I copied the "mondrian-TRUNK-SNAPSHOT.jar" from pentaho-solutions\system\saiku\lib to tomcat\webapps\pentaho\WEB-INF\lib and deleted the...
9. ## Thread: ClassCastException while using CDA

by Heisenberg
Replies
2
Views
223

### I just replaced mondrian-3.5.0.jar by...

I just replaced mondrian-3.5.0.jar by mondrian-3.5.4.jar, sadly with no effect.
This error really starts to annoy me since it makes no sense at all that I get this error while using CDA but at the...
10. ## Thread: ClassCastException while using CDA

by Heisenberg
Replies
2
Views
223

### ClassCastException while using CDA

Dear folks,

I'm facing a strange issue whilst using CDA with pentaho-bi-ce 4.8.0 and cda 13.09.10.

My CDA-File looks like this:

<?xml version="1.0" encoding="utf-8"?>
11. ## Thread: Multi Value List parameter in MDX

by Heisenberg
Replies
3
Views
4,009

### First I want to thank dudinatrix for that post, I...

First I want to thank dudinatrix for that post, I managed using Multivalue Parameterlists in my report now.
I think my question is similar to the one of nirmal:
I want to reference the saleTypes in...
12. ## Thread: Using Pentaho BI-Server In Closed-Source Project

by Heisenberg
Replies
2
Views
673

### Hi folks! I'm still not sure about the...

Hi folks!

I'm still not sure about the licensing thing but I found the following paragraph at wikipedia:

Source:...
13. ## Thread: Can I access/modify pentaho user session from c# .NET?

by Heisenberg
Replies
1
Views
490

You should read about web-sessions and cookies to understand the principles of how logging into a website works technically on the client's side.
What you try to acchive, if I understand you...

by Heisenberg
Replies
2
Views
1,401

### Not sure what you want to do? Your .NET...

Not sure what you want to do?
Your .NET environment has nothing to do with your browser. So even if your .NET Program successfully authenticated itself to the BI-Server, that has nothing todo with...
15. ## Thread: Using Pentaho BI-Server In Closed-Source Project

by Heisenberg
Replies
2
Views
673

### Using Pentaho BI-Server In Closed-Source Project

Hi folks!

I'm confused by all the different information I found in the internet about the usage of GPL'ed software in Closed-Source software.

The scenario:
We want to use the BI-Server for...
16. ## Thread: Configurable Excel Output - Best Practice?

by Heisenberg
Replies
1
Views
576

### Just saw that CDA 12.09.05...

Just saw that CDA 12.09.05 should support usage of Excel Templates. I think this would be the way to go but I can't find any documentation :(

EDIT: So pedrovale from pentaho IRC chat could help me...
17. ## Thread: Configurable Excel Output - Best Practice?

by Heisenberg
Replies
1
Views
576

### Configurable Excel Output - Best Practice?

Hello Community!

I want to be able to export the result of a MDX query as a Excel sheet. I know how to do with CDA and also with a Pentaho Report Viewer.
But I want to be able to configure the...
18. ## Thread: How to combine / join Cube Facts

by Heisenberg
Replies
3
Views
755

### pstoellberger helped me out in the pentaho IRC...

pstoellberger helped me out in the pentaho IRC chat.
The problem was, that the "name" attributes of the dimension usages were not the same as the actual dimension names and the virtual dimension...
19. ## Thread: How to combine / join Cube Facts

by Heisenberg
Replies
3
Views
755

Hello mcampbell,

thanks for your reply. I looked at the example and it could help me a bit.
But now I have the problem that only some combinations of facts and dimensions return values :confused:...
20. ## Thread: How to combine / join Cube Facts

by Heisenberg
Replies
3
Views
755

### How to combine / join Cube Facts

Hello Community.

I have three cubes. Two of them share three dimensions (one of them a Date Dimension), the third one only shares two (one of them a Date Dimension) with the other ones.
The cubes...
21. ## Thread: ETL Transformation fails with ERROR -1 from storage engine

by Heisenberg
Replies
5
Views
801

### Thank you very much for the hint, didn't find it...

Thank you very much for the hint, didn't find it before on google... Will try it right now

EDIT: Nice, .NET Exception while updating... Oh god why :mad:
EDIT2: Installed Fresh Server, runs like...
22. ## Thread: ETL Transformation fails with ERROR -1 from storage engine

by Heisenberg
Replies
5
Views
801

### No, since it's a local installation and my hdd's...

No, since it's a local installation and my hdd's are far from being full I can exclude that as a reason.

EDIT: I'm quite sure it has something todo with deadlocks. It only appears if I use Table...
23. ## Thread: ETL Transformation fails with ERROR -1 from storage engine

by Heisenberg
Replies
5
Views
801

### Hello! The error persists. I also get it...

Hello!

The error persists.
I also get it doing less complex table outputs.
I checked the MySQL logs but nothing to do there.

I worked around the problem in writing the Output, which is my...
24. ## Thread: ETL Transformation fails with ERROR -1 from storage engine

by Heisenberg
Replies
5
Views
801

### ETL Transformation fails with ERROR -1 from storage engine

Hello!

I'm trying to transform a denormalized table with about 600.000 records into a star schema with several lookup/update steps and a table output step for the fact table.
When I check "Use...
25. ## Thread: How to aggregate and transform textual fields

by Heisenberg
Replies
3
Views
350

### Thanks guys, I made it with the sort/group by...

Thanks guys, I made it with the sort/group by steps :)
26. ## Thread: How to aggregate and transform textual fields

by Heisenberg
Replies
3
Views
350

### How to aggregate and transform textual fields

Hello!

I have a table like this:

ID

Identifier
27. ## Thread: Transform multiple, independant tables into a star schema

by Heisenberg
Replies
0
Views
301

### Transform multiple, independant tables into a star schema

Hello all!

I have a problem which I will describe via an example. Lets assume we have four source data tables like this:
10653

We want to use BI on this data to answer the following questions:...
Results 1 to 27 of 27