Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Aggregate tables for columnar DB #1247

Open
jdw89-cs opened this issue Oct 12, 2020 · 0 comments
Open

Aggregate tables for columnar DB #1247

jdw89-cs opened this issue Oct 12, 2020 · 0 comments

Comments

@jdw89-cs
Copy link

I'm working with Mondrian on a columnar DB, means I have a big flat fully denormalized fact table that contains all facts and dimensions. Unfortunately, I am not able to use a aggregate table. When I collapse all dimensions in the aggregate table, Mondrian successfully recognizes the aggregate table. But when I keep e. g. the time dimension, Mondrian does not:

14:06:14,859 WARN  [AggTableManager] Recognizer.checkUnusedColumns: Candidate aggregate table 'agg_days_flattened' for fact table 'flattened' has a column 'dayofMonth' with unknown usage.
14:06:14,860 WARN  [AggTableManager] Recognizer.checkUnusedColumns: Candidate aggregate table 'agg_days_flattened' for fact table 'flattened' has a column 'month' with unknown usage.
14:06:14,860 WARN  [AggTableManager] Recognizer.checkUnusedColumns: Candidate aggregate table 'agg_days_flattened' for fact table 'flattened' has a column 'year' with unknown usage.

Furthermore, the aggregate table is not used when I perform a corresponding MDX query. When I model the same cube with a classical star schema, everything works fine.
For me, it looks like Mondrian neads "true" foreignkey/primarykey mappings to work with agggregate tables, which do not apply to my szenario (big flat fully denormalized fact table).
Does anyone have an idea?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant