Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Apr 16 13:32
    bloussou commented #263
  • Apr 16 13:31
    LisaWolffhugel commented #263
  • Apr 16 13:28
    bloussou commented #263
  • Apr 16 12:56
    LisaWolffhugel commented #263
  • Apr 16 09:46
    patachoux[bot] closed #168
  • Apr 16 09:46
    patachoux[bot] closed #253
  • Apr 16 09:46
    patachoux[bot] closed #255
  • Apr 16 09:46
    patachoux[bot] closed #263
  • Apr 15 15:52
    tibdex unlabeled #256
  • Apr 15 14:49
    bloussou commented #263
  • Apr 15 14:48
    bloussou commented #263
  • Apr 15 14:28
    LisaWolffhugel commented #263
  • Apr 15 14:21
    bloussou commented #263
  • Apr 15 14:20
    bloussou commented #263
  • Apr 15 14:18
    tibdex edited #263
  • Apr 15 14:13
    tibdex edited #263
  • Apr 15 14:12
    LisaWolffhugel commented #263
  • Apr 15 14:09
    bloussou milestoned #263
  • Apr 15 14:09
    bloussou commented #263
  • Apr 15 14:08
    bloussou commented #263
Sam Brown
@SBrown52
Hi. If I don't want to use jupyter and instead create a standalone python application, do I still need to install atoti-jupyterlab?
2 replies
Sam Brown
@SBrown52

Next question.

Is it possible to create a static hierarchy/level object or pass in a string to certain methods? eg take for example the following code to create a shift measure
tt.shift(measure, on=session.cube.levels["Date"], offset=1)

I need to have access to the session object to get the cube and thus the levels.

Is it not possible to do something like
tt.shift(measure, on=tt.level("Date"), offset=1) + another method for passing the dim/hier/level full signature? (ie, have something similar to the static methods in the java api Copper.level(...))

Or, pass a simple string instead of the underlying level

13 replies
lalogp
@lalogp
Hello, I am super new.
I was wondering how to export an atoti dashboard to .html file, is it possible?
I hope you can help me, thanks!
1 reply
Xavier Pilas
@xpilasav
Hello.
When I install atoti following https://docs.atoti.io/latest/install_conda.html, I see it's using the python 3.9.1.
Would atoti work with other previous python versions (3.6, 3.7...) or does it have to be 3.9.1 ?
6 replies
Anastasia Polyakova
@APolyakova
Hello! #vectorization question. I have statistical observations (historical VaR) and trying to make a decision - to vectorize before loading or not. I know about the benefits of vectorization from memory utilization perspective, and also heard that CPUs are more efficient on vectors. How much faster would be atoti.array.quantile comparing to atoti.agg.quantile(pl, scope) if it is faster in atoti?
3 replies
communities-brt
@communities-brt
Hello,
I'm trying to connect Atoti to our database, currently this is working but I had been wondering if there was a way to pass a custom database handler object to the atoti SQL functions. The offered database types listed in the documentation currently is quite limiting, and I was hoping to keep our application open to as many possible environments, but primarily databases that are Hibernate based.
4 replies
Ujjwal Dalmia
@dalmiaujjwal
@jbe456 Apologies for a dumb question this time... does atoti come pre-configured with a web server?
3 replies
communities-brt
@communities-brt
An additional question, is there a way to mount a generated interactive graph/pivot table into a webpage that we built, instead of the Atoti page it naturally publishes to? We are looking to have a pivot table in one of the web pages we are building.
4 replies
Amit Mhatre
@amhatre
Hello,
If I have columns with same name in different joined stores, I will have to rename the columns in one of the stores, which can be done by loading the CSV in pandas, rename the columns and then load from pandas into the store.
However, with this approach, I believe I cannot leverage the file watcher provided by read_csv. In that case, do I implement a watcher using maybe another library (watchdog) or polling the file using the os module?
5 replies
Amit Mhatre
@amhatre
Hi, when setting up a Atoti+ project using the template - https://github.com/atoti/project-template, how to add a dependency on atoti-plus?
2 replies
Anastasia Polyakova
@APolyakova
Hello! I was hoping to have a way to "Drillthrough" by right click on a cell in a pivot table, but this menu doesn't show. Is it expected?
2 replies
Hello! This is a dummy python-atoti question on the default sort (comparator). I want to send a list of buckets in the right order into the comparator like this: lvl[\"Tenors\"].comparator = tt.comparator.first_members(bucket_definitions) However this will not result in the order being picked up (and no exceptions/warnings). What works is - listing tenors in brackets, for example first_members("1Y", "2Y", "3Y"). What can I do if I maintain the tenors order in python in a list?
3 replies
Anastasia Polyakova
@APolyakova
Hello! This is a question about the branding feature of Atoti+. I'm trying to apply a corporate color schema to the atoti app. I managed to change the icon, favicon, title. But changing the accent_color doesn't modify anything in the UI. What is the accent_color supposed to control? Thank you
2 replies
Yeo Hui Fang
@HuifangYeo
Hi, referring to [atoti.read_sql()](https://docs.atoti.io/latest/lib/atoti.html#atoti.session.Session.read_sql) function, is there anyway we can configure the password for the database without showing the password in clear string?
2 replies
Amit Mhatre
@amhatre
Hello, question about logging, is there a way to configure the log file name, location and log rotation policy? are the spring boot properties supported?
3 replies
Anastasia Polyakova
@APolyakova
Hi team, me and my colleague are trying to use the branding feature in Atoti+. In our project we have set the favicon and the logo to the same ".ico" file: branding=tt.config.create_branding( favicon="./favicon.ico", logo="./favicon.ico",) The favicon does get updated, but the logo shows as if there's a broken link to the image. The settings work for me on a mac, but not for my colleague who is on a windows machine. What can be a reason and what can we try? Thank you for support...
2 replies
Jose Perez Prol
@lepepe
Hello! I'm new to Atoti and I was wondering if there is a way to set session port to 80?
2 replies
Brieuc Loussouarn
@bloussou
Hello ! We just released atoti 0.5.2! Here are some highlights:
  • mode="raw" boosting performance for large query results. Benchmark coming soon!
  • Query methods can return the grand total and sub totals.
  • Faster and atomic data loading with transactions.
  • Many UI goodies: column resizing, defer updates mode, quick expand...
  • Project template as a starting point for projects to go into production.
Jose Perez Prol
@lepepe
Hello, I'm in interested in Atoti+, I did try contact ActiveViam via the contact form but I did not have any answer yet; can you guys help me with that or direct me to the right site? Thanks!
1 reply
Yeo Hui Fang
@HuifangYeo
Hi, I was playing with a remote cube - remote querying in the documentation. Since we are able to get the measures,
  • can we create the measures into the remote cube?
  • if not, can we make a clone of the remote cube which will allow us to create new measures on top of the what has been created in the remote cube?
6 replies
ozw1z5rd
@ozw1z5rd
Hello atoti! I need help to install atoti on Hadoop 3.0.0-cdh6.3.4 ( cloudera ) for evaluation purposes.
Where can I find an How-To?
36 replies
ozw1z5rd
@ozw1z5rd
Any older package with 2.7 support?
1 reply
Brieuc Loussouarn
@bloussou
Hi, in auto mode do you often use int columns as levels ? Or are int columns mostly used in measures in your different projects ?
ozw1z5rd
@ozw1z5rd
Hello all, is someone experiencing issues when connecting excel to the docker image?
2 replies
Jose Perez Prol
@lepepe

Hello! I just upgrade to version 0.5.2 and then I'm getting the following error:

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-18-d002a4b84b45> in <module>
----> 1 import atoti as tt
      2 config = tt.config.create_config(
      3     metadata_db="data.db",
      4     port=8080

~/.pyenv/versions/3.9.1/lib/python3.9/site-packages/atoti/__init__.py in <module>
     41 
     42 
---> 43 (_EDITION, _LICENSE_END_DATE, _IS_COMMUNITY_LICENSE) = retrieve_info_from_jar()
     44 __edition__ = str(_EDITION)
     45 

ValueError: not enough values to unpack (expected 3, got 2)

This is my session config:

import atoti as tt
config = tt.config.create_config(
    metadata_db="data.db", 
    port=8080
)
session = tt.create_session(config=config)
session.load_all_data()
session.url
18 replies
ozw1z5rd
@ozw1z5rd
Hello all,
I'm facing some issues in converting this :
{​​​​​​​NULL:[Date].[Time].CURRENTMEMBER} from MS cube to ATOTI​​​​​​​

The Cube defines in MDX a measure

CREATE MEMBER CURRENTCUBE.[Measures].[Unredeemed Cumulative] AS AGGREGATE(
{​​​​​​​NULL:[Date].[Time].CURRENTMEMBER}​​​​
​​​ * {​​​​​​​NULL:[Date].[Year - Week].CURRENTMEMBER}​​​​​​​,
([Measures].[Unredeemed])
),
VISIBLE = 1 ,
ASSOCIATED_MEASURE_GROUP = 'V';
did anybody face a similar cube porting issue?

7 replies
ozw1z5rd
@ozw1z5rd
Just for curiosity: is here some SSAS -> ATOTI cube migration how to?
1 reply
Julien Bec
@jbe456

Hey everyone, we want to hear from you!

Sign up to do an atoti UX interview with Sara Simonovska and bag yourself a 💰 €50 gift card 💰 if you're picked.

Sounds good? Sign up now!

Sam Brown
@SBrown52

Hi, where is the best place to put properties in an atoti application? I thought I could reuse the config.yml file that atoti.create_session uses, but it appears that this only accepts certain keywords.

In a java world I would use the application.yaml and Spring's Environment - I am looking for the python/atoti equivalent.

19 replies
communities-brt
@communities-brt
Hi, Newly setting up an ActivePivot server for the first time with a front end using ActiveUI. I'm using the default sandbox application for ActivePivot and when its running we can go to the localhosted URL and access everything after providing the user and pass but when trying to access it through ActiveUI it gets a 401. I'm assuming its because the requests also need the user and pass in some form but was unsure where to add this or what needs to be changed to have the front end be able to be properly authorized? Also open to removing the auth as in my system auth is already covered elsewhere and I don't need it being done within ActivePivot as well.
5 replies
Yeo Hui Fang
@HuifangYeo

Hi,

Does the create_date_hierarchy function take datetime data type?

7 replies
LisaWolffhugel
@LisaWolffhugel
image.png
Hi guys, I have few questions : is there a way to create a measure with the "at" method and specifying the allMember value instead of another member ? When I use : cube_measures["Surface Totale"] = tt.total(
cube_measures["Surface.SOMME"],
cube_hierarchies["ID_unit"]
) the total is changing depending on the hierarchy I'm adding to the mdx .
2 replies
In my case I would like to have 4,412 on all lines for all members whatever the hierarchy I use
LisaWolffhugel
@LisaWolffhugel
Another question still regarding the "at" method. I have these measures where I once specify the type_unit level in the method and some where I don't . the expected result is the one from the 1st measure ( same value on all members) but how can I make it work for all hierarchies without having to specify all levels ?
5 replies
image.png
thanks
Nestor Zepeda
@NZepeda

Hello,

Is there any documentation available on enabling SSL on an atoti docker container? This container is deployed on Amazon ECS and so we need to be able to supporthttps traffic.

3 replies
LisaWolffhugel
@LisaWolffhugel
Hi guys, reading a csv with Date, year, month, week, day as column when I create my cube everything works but when I want to create a multilevel hierarchy with Year/Month/Day I get this error.
image.png
any idea why ? all columns are read as INT and the hierarchy and level already exist
3 replies
Sam Brown
@SBrown52
If I wanted to load hdf5 files into atoti, what does the atoti team recommend? Load the data into pandas first and then load a pandas dataframe into atoti or is there another api to load directly? (FYI this comes from an existing java based project which uses a custom HDF5 source)
3 replies
LisaWolffhugel
@LisaWolffhugel
image.png
image.png
sorry @tibdex I can't succeed to send the picture on the answer thread
7 replies
Raghav Vashisht
@rvs36
Hello,
I am trying to do some EDA with atoti for a dataset.
I was just curious if we can do a univariate analysis in atoti?
2 replies
Daniel Taylor
@Skyscimitar
Hello,
atoti 0.5.3 has been released. The highlights are:
  • Define aggregated measures by combining multiple store columns efficiently
  • Better search experience in the docs
  • UI goodies: tree table layout and drillthrough widget available in JupyterLab