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
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")
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.
Amit Nayek
@anayek_gitlab
/home/administrator/anaconda3/envs/willocube/lib/python3.7/site-packages/cubes/metadata.py(76)_json_from_url()
-> raise SyntaxError("Syntax error in %s: %s" % (url, str(e)))
(Pdb) --KeyboardInterrupt--
unable to understand .. ?
Subhan Khalid
@subhanKhalid
When I run slicer serve slicer.ini my zsh terminal returns bad interpreter. Any idea why? I will greatly appreciate your help. Thanks!
Subhan Khalid
@subhanKhalid
Hello? is this place still active?
Subhan Khalid
@subhanKhalid
well, I'm trying to run slicer serve slicer.ini inside my python env but I get the bad interpreter error
Subhan Khalid
@subhanKhalid
wtf....goodbye i guess this is a dead project lol
Ben McNeill
@bfmcneill
It looks like this project has been around for a while. Is anyone here running in production?
Kirill Marchuk
@62mkv
Hi @bfmcneill this framework was mostly developed by single person, who is now doing something else, so don't expect too much activity in this chat or in the github issues.
concerning if anyone is running this in production, maybe there were some hints in the history of this chat. Also I remember there was a Google Group as well
Julien Bec
@jbe456

Hello everyone, if you are looking for an OLAP cube Python library, you can check out https://atoti.io

Disclaimer: I'm working for the atoti project.
(I precise I took the liberty to mention it since this project is not maintained anymore)

Christian Ledermann
@cleder
@jbe456 Can you give the elevator pitch? I really like cubes, so how does atoti compare?
Kirill Marchuk
@62mkv
@jbe456 cool to hear about alternatives! wish you all the best with this!
so, it's not open-source?
Julien Bec
@jbe456
@cleder atoti is like a combination of "tableau/power bi" served directly from a Jupyter notebook and an aggregation engine a bit like Pandas/Spark but in-memory & OLAP. You can also use Excel to connect to it.
Julien Bec
@jbe456
@62mkv it's not open source but free to use for personal/prototyping/notebook usage. It's using a licensed JAVA technology that has been used for 15 years in finance & retail. If you are curious about the technical details, you may look at this white paper (different product but it shares most of the features): https://activeviam.com/images/pdf/white-papers/ActiveViam_Technical_White_Paper_-_ActivePivot.pdf
cyaninja
@cyaninja
Hi everyone! I was wondering if it's possible to connect the cube to excel?
5 replies
As in use Get Data in excel to connect and create pivot tables in excel
Jose Juan Montes
@jjmontesl
I guess you could retrieve the facts in CSV format and use Excel functionality for pivoting.
If you wish to connect Excel to Cubes using Cubes as a backend for aggregated queries, then no, that's not possible.
If you just wish to retrieve CSV facts you can do so using /facts?format=csv in your query, like for example: http://cubesdemo.cubesviewer.com/cube/webshop_sales/facts?format=csv
cyaninja
@cyaninja
Thanks @jjmontesl and @jbe456 for the replies
I have some dim and fact tables stored in an API callable cloud service
The cloud service provides a really bad excel add-in
and I was looking at calling the api and constructing the cube to serve reporting needs, all within excel
all with *python
Jose Juan Montes
@jjmontesl
then, I don't know... I don't know how to serve an Excel-compatible service, sorry