All Questions
8 questions
0
votes
1
answer
108
views
How to create a schema with./configure in mysql?
I am completely new to MySQL and the schema we need to use is a Copy of our production environment, which is on a different provider.
Basically from Oracle with a Tool we need to Copy a couple of DB ...
- 47
0
votes
1
answer
167
views
MySQL Tables / Schema are duplicating themselves
All of a suddned I noticed that my tables have began to duplicate themselves and I don't know why or what I have done to cause this. Does anyone know? The last thing I remember doing is setting up ...
- 91
0
votes
1
answer
463
views
Pentaho Schema Workbench dimension attributes
I use PSW 3.5.11. I have a classic dimension for people (sex, ethnicity, religion, study level, etc.) and people code.
How can I create this dimension to use each attribute alone and not as a level?
...
- 23
0
votes
1
answer
571
views
Pentaho Schema Workbench not able to start
Pentaho Schema Workbench not able to start, it seem the program detect wrong path as screenshot below ";\bin\java".
I try all the way to set in Environment variable but no luck.
Environment ...
- 726
0
votes
1
answer
677
views
pentaho schema workbench time dimension foreign key base
In my schema I have a time dimension based on foreing key, that conects with fact table. When displayed values like years at column and month at row the values are showed like image
How I do to ...
- 73
0
votes
1
answer
1k
views
pentaho schema workbench no publish password option
I am currently using Schema workbench 3.6.1. I created a data cube and I am trying to publish it in pentaho bi-server. In every tutorial I've seen after clicking on publishing the pop up window looks ...
- 4,641
0
votes
1
answer
2k
views
I got "unknown database" when creating a new connection in Workbench 6.3
I am using Workbench 6.3 in Windows 8 and I want to create a new connection using a default schema that I have created. The schema's name is "mydeptosdb" and it is on Models. When I create ...
- 1,455
0
votes
1
answer
650
views
Is using Views with SQL Join Queries in OLAP Cube a good practice?
I'm trying to create my first olap cube schema for Mondrian server.
I came up with creating a view as a fact table with several joins to put foreign keys into it, let's say it looks like this:
SELECT ...
user2659701