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 2019 11:40
    pktippa synchronize #467
  • Jan 23 2019 11:30
    pktippa edited #467
  • Jan 23 2019 11:30
    pktippa synchronize #467
  • Jan 23 2019 09:37
    pktippa opened #467
  • Jan 23 2019 09:35
  • Jan 21 2019 16:20
  • Jan 16 2019 03:18
    alexanderfefelov commented #332
  • Jan 05 2019 05:20
    jjmontesl labeled #449
  • Jan 05 2019 05:20
    jjmontesl labeled #449
  • Jan 05 2019 05:19
    jjmontesl assigned #449
  • Jan 05 2019 05:19
    jjmontesl commented #449
  • Jan 05 2019 05:17
    jjmontesl labeled #451
  • Jan 05 2019 05:16
    jjmontesl assigned #451
  • Jan 05 2019 05:16
    jjmontesl closed #451
  • Jan 05 2019 05:16
    jjmontesl commented #451
  • Jan 05 2019 05:11
    jjmontesl milestoned #445
  • Jan 05 2019 05:11
    jjmontesl labeled #445
  • Jan 05 2019 05:10
    jjmontesl unassigned #445
  • Jan 05 2019 05:10
    jjmontesl assigned #445
  • Jan 05 2019 05:10
    jjmontesl closed #445
Christian Ledermann
@cleder
cubes viewer is written with angularjs and d3js charts so to integrate amcharts you will have to rewrite it
Christian Ledermann
@cleder
OT: have you seen https://github.com/kayak/fireant looks like something to have an eye on
leowmjw
@leowmjw
My
Christian Ledermann
@cleder
I try to denormalize my cubes but the denormalize fails
slicer sql denormalize --config=slicer.ini

Error: config should be a ConfigParser instance, but is <class 'str'>
or
slicer sql denormalize slicer.ini

Error: config should be a ConfigParser instance, but is <class 'str'>
Christian Ledermann
@cleder
slicer serve runs fine
slicer serve slicer.ini
2017-07-26 17:59:16,286 DEBUG Models root set to current directory
2017-07-26 17:59:16,286 DEBUG Workspace calendar timezone: None first week day: 0
2017-07-26 17:59:16,417 DEBUG Registered store 'default'
2017-07-26 17:59:16,417 DEBUG Loading model main
2017-07-26 17:59:16,417 DEBUG Importing model from model.json. Provider: None Store: None NS: None
...
Cubes version 1.1
Michael Schwab
@schwab
@cleder on Apr 04 I asked the same question about denormalization. If you scroll back far enough on this thread, you can see the interaction I had with @Stiivi about it. His suggestions got me going. In short there is a bug in the denorm stuff and you have to edit the py code to correct for some changes that have been made. In my case I got it working but found the denorm really did almost nothing for the performance. Including better indexes in my sql model was way more effective.
Also, note that de-norm does not pre-aggregate (like the MS Analysis services product does). I had assumed that would be the effect. Instead it flattens out any joins making a single flat table of your data.
Christian Ledermann
@cleder
@schwab thanks, I do not need denormalization for performance reasons but to use the data in another tool that does not support cubes
Christian Ledermann
@cleder
@schwab Yes thats what I need it for - a single flat table :smile:
Jonathan Drake
@drakej_twitter
Is there a way to provide a measure column mapping?
Jonathan Drake
@drakej_twitter
Also can you make a PointCut using a dimension attribute other than id?
simkimsia
@simkimsia

We built a django app for product warehousing. Increasingly, the requests are for reporting such as knowing the quantity of the SKU by date etc.

I have looked at cubes. I am not sure if it's overkill to have cubes and Django at the same time. I could add new features to the django app but i was wondering if there's a better way to do this than to sprinkle a bunch of update statements in order to do aggregates that are then stored in another datatable in the postgres database.

Currently, the number of reports we are asked to do is 2. It may grow to 8.

Advice?

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.
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