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