Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 23 11:40
    pktippa synchronize #467
  • Jan 23 11:30
    pktippa edited #467
  • Jan 23 11:30
    pktippa synchronize #467
  • Jan 23 09:37
    pktippa opened #467
  • Jan 23 09:35
    pktippa forked
    pktippa/cubes
  • Jan 21 16:20
    anke522 forked
    anke522/cubes
  • Jan 16 03:18
    alexanderfefelov commented #332
  • Jan 05 05:20
    jjmontesl labeled #449
  • Jan 05 05:20
    jjmontesl labeled #449
  • Jan 05 05:19
    jjmontesl assigned #449
  • Jan 05 05:19
    jjmontesl commented #449
  • Jan 05 05:17
    jjmontesl labeled #451
  • Jan 05 05:16
    jjmontesl assigned #451
  • Jan 05 05:16
    jjmontesl closed #451
  • Jan 05 05:16
    jjmontesl commented #451
  • Jan 05 05:11
    jjmontesl milestoned #445
  • Jan 05 05:11
    jjmontesl labeled #445
  • Jan 05 05:10
    jjmontesl unassigned #445
  • Jan 05 05:10
    jjmontesl assigned #445
  • Jan 05 05:10
    jjmontesl closed #445
priti-energysavvy
@priti-energysavvy
All of my data is stored as UTC, is there a way to display it in PST instead? Postgres has an AS TIME ZONE command, but I don't know if Cubes takes advantage of it/
zejn
@zejn
@priti-energysavvy If you're using timezone aware timestamps, you can set timezone at connection time -- https://www.postgresql.org/docs/9.1/static/sql-set.html
priti-energysavvy
@priti-energysavvy
@zejn I have been looking at setting timezone that way, but don't understand where 'connection time' occurs. Is that 'create_server' ?
zejn
@zejn
@priti-energysavvy Looking at the code again it seems it's easiest if you set timezone per user using ALTER USER.
SQLAlchemy doesn't seem to have a hook when connection is created, and cubes seems to use engine directly.
priti-energysavvy
@priti-energysavvy
I ended up creating a view with datetime columns converted to the timezone I want (using AS TIME ZONE) and using the view for cubes instead of a table. It seems to work pretty well. :) Thanks for your responses!
Michael Schwab
@schwab
Is it possible to join fields from 2 tables into a single dimension? In my case I have a fact table joined to a dim table (dim_drugs), which has a column which is a FK to another lookup table (dim_drug_admin). I'd like to create a single dimension that has levels from both the dim_drugs and dim_drug_admin table such that drill downs can be performed through hierarchy information from both tables. It seems this should be possible, but I haven't seen an examples which show how this could work. Is it possible to accomplish this or is the only solution to flatten the 2 dim tables into a single one with the cross product of data from both? (assume the dim_drug and dim_drug_admin tables are join on a unique id for instance)
Michael Schwab
@schwab
Found a way to do this, for those who see it later. Under the schema's discussion in the docs there is a small section on Mappings. These allow columns to be combined from other tables into a single dimension. Works well.
Michael Schwab
@schwab
Is it possible for slicer to filter the results based on the value of an aggregate? In my case I'd like only to return the rows where record_count is greater than a value. I've tried expressing this in the cut and in the aggregation clause but neither seem to work. Is this even possible it must it be done only in post processing?
Stanislav Petrenko
@spetrenk
Hi guys, I’m new to this package and I’m looking to explore some of its functionality. I wanted to know if it’s possible to query and existing OLAP cube using an MSOLAP engine with this package?
KBA
@KhaledTo
Hi @spetrenk, to me it would make sens to use cubes with a SQL Server database but not really with SSAS. But I'm not sure if I got your question correctly.
KBA
@KhaledTo
Any news on this project? It's too bad such a great project has not much updates.
Rufus Pollock
@rufuspollock
@KhaledTo i know the maintainer really well and he's been super busy with his day job. If you are interested in specific support you can contact us at https://datopian.com/#contact and i'll try to pass it on.
KBA
@KhaledTo
Well I just wish this project was more active, I want to contribute to it, but I'm not even sure my changes would get merged if I did. Maybe someone who has time should maintain this project.
Thank you for your reply @rufuspollock
Michael Schwab
@schwab
The good news is that as it stands the library is very usable. I recently released a production system using cubes as the database backend. This is a strictly read setup but it does handle the aggregations and cube processing very well, even top of a mariadb.
Rufus Pollock
@rufuspollock
@schwab :-) -- it's a great library Stefan is a very good data engineer and software architect :-)
KBA
@KhaledTo
It is a great library indeed @schwab , but there are many things to do to push it to the next level.
Hai
@yuhai1023

Hi, All:
I am new to cubes and found that newly cubes has remove the mongo Store from version 1.1, which the old one still contains. Could anyone tell me how to install this extension into cubes 1.1. I install it from pip install cubes.

Many thanks.

Michael Schwab
@schwab
Not sure about that Hai, but have you checked the issues on https://github.com/DataBrewery/cubes/issues. If it's not there already you can add a new issue.
Vladqqw
@Vladqqw_gitlab
Hello, as I can on the already working slicer add storage and cubes?
Jose Juan Montes
@jjmontesl
Hi there.
Jose Juan Montes
@jjmontesl
I have merged a breaking change to master. If any of you could test the latest master with your configurations and check it'd be nice. It requires changing flat dimension mappings (ie. 'genre') to their full dimension.levelattribute: 'genre.genre'
(full discussion in #441)
Jose Juan Montes
@jjmontesl
Hi. I'll be working on CubETL for 3 hours. If anybody has a database or dataset you want to load and visualize, and give it a try, I can provide support.
(https://github.com/jjmontesl/cubetl)
Pradeep Kumar Tippa
@pktippa
Hi
I need some help on how to incrementally update an already existing Cube.?
Jose Juan Montes
@jjmontesl
Just add new rows to the corresponding database tables?
Pradeep Kumar Tippa
@pktippa
Thanks havent verified it, since it is missing in the documentation asked it here.
After adding the data to the corresponding database tables do we have to run aggregate again?
Jose Juan Montes
@jjmontesl
You need to aggregate again, yes, for Cubes to run a new query on the database, which would then include the new rows.
...how are you querying Cubes? from Code? via HTTP?
reywang18
@reywang18
Any video training for this .. Thanks
Jose Juan Montes
@jjmontesl
This one is for an older version but the general concepts apply: https://www.youtube.com/watch?v=qRfkmRn8i18
Another one in Spanish (high level OLAP concepts): https://replay.teltek.es/video/59477fd4a7bc28cd1b8b45b3
Pradeep Kumar Tippa
@pktippa
@jjmontesl for our requirement we need to query Cubes both from Code and HTTP.
Pradeep Kumar Tippa
@pktippa
Can we use custom functions in aggregates where conversions are required. Ex:
lets say we have attendance data with column is_present which is a boolean data type and want to count how many are present and how many are not.
Jose Juan Montes
@jjmontesl
@pktippa I haven't used Cubes from code, sorry.
These are the functions defined in functions.py:
    SummaryCoalescingFunction("sum", sql.functions.sum),
    SummaryCoalescingFunction("count_nonempty", sql.functions.count),
    FactCountFunction("count"),
    FactCountDistinctFunction("count_distinct"),
    ValueCoalescingFunction("min", sql.functions.min),
    ValueCoalescingFunction("max", sql.functions.max),
    ValueCoalescingFunction("avg", avg),
    ValueCoalescingFunction("stddev", stddev),
    ValueCoalescingFunction("variance", variance)
Maybe you can use sum to count true values, but I'm not sure whether you can use booleans like that.
Pradeep Kumar Tippa
@pktippa
Yes I used custom aggregate to do sum of Boolean true values.
I used same name as "sum".
But when I try to use a different custom name "sumofbooelans" it is failing.
KBA
@KhaledTo
Can someone explain me why we have raise NotImplementedError("Depreciated in this context")
there: https://github.com/DataBrewery/cubes/blob/140133e8c2e3f2ff60631cc3ebc9966d16c1655e/tests/common.py#L54
KBA
@KhaledTo
@jjmontesl any news about the roadmap?
lawrenceyang
@lawrenceyang
new to cubes, learning the code, try to a replacement for SSAS, anyone have the experience for replacing the SSAS
KBA
@KhaledTo
@lawrenceyang depends on what you are doing with SSAS. At the moment I wouldn't replace SSAS with cubes in production.
ThamaluM
@ThamaluM
I have product and time dimension table. I want amount_sum for product drilldown. I want products that were never sold in my result as
I have product and time dimension table. I want amount_sum for product drilldown. I want products that were never sold appear in my result as amount_sum = 0. We can use outer join for product table. But when we cut by time these products disappear from result again. How can we fix the issue. Is there any alternative way.