Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Jun 20 13:32
    blair-anson labeled #304
  • Jun 20 13:32
    blair-anson opened #304
  • Jun 18 14:32
    bloussou commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
  • Jun 18 14:30
    review-notebook-app[bot] commented #152
sanjaydatasciencedojo
@sanjaydatasciencedojo
Is atoti open source or proprietary?
2 replies
Sam Brown
@SBrown52
How come you removed the doc on querying an existing cube? It was really useful, much better having that in the tutorial vs trying to piece things together in the API reference
https://docs.atoti.io/0.4.0/tutorial/08-Queries.html
6 replies
carliny
@carliny
Hi, I am a beginner here and I am trying to run the SA-CCR notebook but it gets stuck when calculating Add-on for interest rate derivatives - [52.56]...I have not changed any data, just running the notebook as is.....can you help??
3 replies
rameshsynt
@rameshsynt
Hi Am getting the below error while viewing the store
1 error(s) occurred while feeding the store Sdlist. Check the store's loading_report for more details.
may i know how to view the store loading report
1 reply
Samuel Parra
@butterfly.sparra:matrix.org
[m]
Hi Folks
Im starting to learn atoti
Post run session.visualize()
does'nt open left panel from Jupiter
I can't see interactive visualizations such as pivot tables and charts directly into my notebook post calling session.visualize()
1 reply
could yu help me please
Samuel Parra
@butterfly.sparra:matrix.org
[m]
*you
Gaurav Shukla
@shukla2103
Hi Folks
I have just started using atoti and would like to know can we use this host like a web application like tableau with login credentials
1 reply
To be more specific i want to utilize this in agri insurance sector for KPIs
Gaurav Shukla
@shukla2103
Also can I integrate it with some web portal
1 reply
Gaurav Shukla
@shukla2103
Okay got it those features are of paid version
navin7317
@navin7317
how to show values on top in the chart (line/bar)
2 replies
Mustafa Saeed
@mustafadalil:matrix.org
[m]
Hello everyone, please excuse if this is so basic I just started using atoti. My question is that I cannot load the whole data to atoti even when using session.load_all_data(), sampling happen regardless. I have been trying to work around this but failed so far.
2 replies
Alexander Cyrus
@alexanderone:matrix.org
[m]
Hello I started playing with atoti as a light data visualization tool recently. I deployed it on on Google Cloud using Cloud Run service. However, I do not know what is the best way to persist the dashboard data configured by create_config method and metadata_db arguemnt in Google Could Run. I create a docker and then deploy the docker on Google Cloud, after running the container if there is no http request the container automatically stops to save resources. If the data is not persisted, the next time the container starts all the dashboard metadata is lost. I do not know what is the easiest way to persist data in my case. I would appreciate any comments
4 replies
Yeo Hui Fang
@HuifangYeo
Hi, how can I prevent tt.rank from including the Total?
image.png
10 replies
bhuvan-git
@bhuvan-git
Hi
1 reply
bhuvan-git
@bhuvan-git

Hi, how I can connect to a secured cube from a python script, I am trying following code but it is giving me error
Code:
from datetime import date
import pandas as pd
import atoti as tt

print("Auth")
username = 'dummy@test'
password = 'dummy'
auth_str = tt.query.create_basic_authentication(username, password)

print(auth_str)
session = tt.open_query_session('http://localhost:52128',name=None,auth = auth_str)

print("Connection Sucessfully")

Error:

<function create_basic_authentication.<locals>.<lambda> at 0x000001B0DC731DC0>
Traceback (most recent call last):
File "C:\Users\singbhu\Documents\Documents\tutorial\AtotiSession.py", line 12, in <module>
session = tt.open_query_session('http://localhost:52128',name=None,auth = auth_str)
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti_type_utils.py", line 196, in typechecked_func_wrapper
return self._func(args, *kwargs)
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti_sessions.py", line 134, in open_query_session
query_session = QuerySession(url, auth=auth, name=name)
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti\query\session.py", line 137, in init
self._version = self._fetch_version()
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti\query\session.py", line 187, in _fetch_version
response = self._fetch_versions()
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti\query\session.py", line 184, in _fetch_versions
return self._execute_json_request(url)
File "C:\Users\singbhu\AppData\Roaming\Python\Python39\site-packages\atoti\query\session.py", line 179, in _execute_json_request
error_data = json.loads(error_json)
File "C:\Program Files\Python39\lib\json__init__.py", line 346, in loads
return _default_decoder.decode(s)
File "C:\Program Files\Python39\lib\json\decoder.py", line 337, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "C:\Program Files\Python39\lib\json\decoder.py", line 355, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

5 replies
bhuvan-git
@bhuvan-git
image.png
TasneemAhmed
@TasneemAhmed
Hello, when I start coding writing "import atoti as tt" , give me this error:"Exception: Your Atoti+ license has expired, contact ActiveViam to get a new license.
". what I can do to solve this problem?
5 replies
Yeo Hui Fang
@HuifangYeo
Hi, how do we change the data type of a measure? image.png
2 replies
Gokul Balasubramanian
@gbactiveviam
Hi, is there a way to control/specify allowed-origins in Atoti+?
2 replies
Gokul Balasubramanian
@gbactiveviam
Hi, to run Atoti+, do I need to have a separate env variable called ATOTI_LICENSE or will ACTIVEPIVOT_LICENSE suffice?
2 replies
Yeo Hui Fang
@HuifangYeo
Hi, where I run conda update atoti, it shows that atoti-jupyterlab is also updated.
However, when I try to run jupyter lab, it throws an exception. Running conda update atoti-jupyterlab will work.
TasneemAhmed
@TasneemAhmed
image.png
I create this schema using this code: affected_region_store.join(storm_store , mapping={"Storm_ID":"Storm_ID"})
, if I want to add another relationship between affected region table and another table called region in the schema, what code I can do for this?
2 replies
Adjaysagar
@Adjaysagar
Hello Everyone, I'm new to Atoti and just playing around with the Free version. Are the features like formatting in Pivot tables only available with the Premium version? Why do almost all tutorials on Medium show Atoti having the formatting feature, Thanks in advance!
1 reply
Alexander Cyrus
@alexanderone:matrix.org
[m]
Hello, I am creating a dashboard but I want to hide some of the dimensions while keeping the measures created dependent on them. In the documentation there is a way to hide or delete measures but I have not found a way to hide dimensions.
3 replies
Xavier Pilas
@xpilasav
Hey atoti team.
While following the tutorial to install atoti using conda or pip, I have some dependencies which are filtered and that blocks my installation. Would you have a way to get a packaged version of atoti to be downloaded and that I can deploy/install ?
5 replies
Hi again. Question regarding jdk4py 11.0.9.0 on pypi. Is there a license on this version ? I don't see anything on the meta section
7 replies
TasneemAhmed
@TasneemAhmed
image.png
Hi again
TasneemAhmed
@TasneemAhmed
On the left side in the Query editor section, can this editor takes the query from another model(Bert model which converts natural language question into SQL query) take this query, and generate a chart, if not applicable, how can the query from the Bert model and convert it to chart?
1 reply
vibhorbaijal
@vibhorbaijal

Hi All, I am new in using atoti and getting the below error.import atoti as tt

session = tt.create_session()

sales_superstore = session.read_csv(r"‪C\Users\VIBHOR\Desktop\Sample - Superstore.csv", keys=["Order ID"])

AtotiJavaException Traceback (most recent call last)

<ipython-input-14-5ef80f0f1a5e> in <module>
----> 1 sales_superstore = session.read_csv(r"‪C\Users\VIBHOR\Desktop\Sample - Superstore.csv", keys=["Order ID"])

E:\learning\lib\site-packages\atoti_type_utils.py in typechecked_func_wrapper(args, **kwargs)
194
195 # Call the actual function.
--> 196 return self._func(
args, **kwargs)
197
198 # Mark the function as typechecked and return it.

E:\learning\lib\site-packages\atoti_docs_utils.py in wrapper(args, **kwargs)
14 @wraps(func)
15 def wrapper(
args: Any, kwargs: Any) -> Callable:
---> 16 return func(*args,
kwargs)
17
18 # Collecting docstring and docstring templates

E:\learning\lib\site-packages\atoti\session.py in read_csv(self, path, keys, store_name, in_all_scenarios, sep, encoding, process_quotes, partitioning, types, watch, array_sep, sampling_mode, hierarchized_columns)
269 # Load the CSV into the store
270 mode = sampling_mode if sampling_mode is not None else self._sampling_mode
--> 271 CsvDataSource(self._java_api).create_store_from_csv(
272 path,
273 store_name,

E:\learning\lib\site-packages\atoti_sources\csv.py in create_store_from_csv(self, path, store_name, keys, in_all_scenarios, sep, encoding, process_quotes, partitioning, types, watch, array_sep, pattern, sampling, hierarchized_columns)
62 path, sep, encoding, process_quotes, array_sep, pattern
63 )
---> 64 self.create_store_from_source(
65 store_name,
66 keys,

E:\learning\lib\site-packages\atoti_sources__init__.py in create_store_from_source(self, store_name, keys, partitioning, types, sampling, in_all_scenarios, watch, source_params, hierarchized_columns)
50 hierarchized_columns: The columns to convert into hierarchies
51 """
---> 52 self._java_api.create_store_from_source(
53 store_name,
54 self.source_key,

E:\learning\lib\site-packages\atoti\exceptions.py in catch_py4j_exceptions(java_api, args, *kwargs)
71 else f"{java_api.get_throwable_root_cause(java_exception.java_exception)}"
72 )
---> 73 raise AtotiJavaException(
74 cause,
75 str(java_exception),

AtotiJavaException: File not found C:\Users\VIBHOR\‪C\Users\VIBHOR\Desktop\Sample%20-%20Superstore.csv

6 replies
Tony Chen
@tchgitav
with the atoti python api, how does one rename a datastore field or a hierarchy/level to a desired name rather than what is given in the data files. For example if a column in my data file was market_value_usd and I wanted on the ActivePivot side to show as MarketValueUsd; how can I achieve that?
14 replies
TasneemAhmed
@TasneemAhmed
is there any tool or API which converts SQL query into MDX query and uses this converted MDX query to create a chart in jupyterlab notebook?
1 reply
Hetal Kapadia
@printhellohetal

Attempting to help someone install atoti on a windows machine, and getting the following error when creating the atoti environment. I don’t have this issue on neither my mac nor linux setup, so a bit stumped. Any thoughts/help on what is causing the connection to fail?

(base) PS C:\Users\Xavier> conda config --add channels https://conda.atoti.io
(base) PS C:\Users\Xavier> conda create --name atoti
Collecting package metadata (current_repodata.json): done
Solving environment: done

CondaHTTPError: HTTP 000 CONNECTION FAILED for url https://conda.atoti.ioc/win-64/current_repodata.json
Elapsed: -

An HTTP error occurred when trying to retrieve this URL.
HTTP errors are often intermittent, and a simple retry will get you on your way.
'https://conda.atoti.ioc/win-64'

5 replies
piyuw
@piyuw
Hi Everyone, I've just installed atoti using the following link on a digital ocean cluster : https://www.atoti.io/the-ultimate-deployment-guide-for-atoti-on-aws-with-amazon-ec2/ . Everything is working fine apart from when I wanted to go ahead and format KPI widgets as per the following link : https://medium.com/atoti/dynamic-pivot-tables-in-notebooks-atoti-e4e4fd334ebc . There is a section on formatting that allows for cell styles to be changed, however i cannot find that button in the atoti installed. Im trying to get similar formatting like this from the SA-CCR notebook in the atoti gallery : it would be much appreciated if someone can please let me know what im missing. Is it a package that i need to install ? or is it something else ?
9 replies
image.png
2 replies
piyuw
@piyuw
@HuifangYeo Please see the above message. In addition to the above comments, I've also tried to run the notebooks like the SA-CCR in jupyter lab. But the Setting up of the sessions fails to restore the metadata.db that is part of the notebook. It only works, when the folder is deleted. Which means whatever graphs and formats that have are but of the gifs in the notebook are all lost. Any advice on this would also be much appreciated ! thanks.piyuw
4 replies
Yeo Hui Fang
@HuifangYeo
Hi, I've created a cube with vector in the base store.
Can I know what should be the expected value of the vector.MEAN and vector.SUM?
image.png
2 replies
Xavier Bellouard
@xbellouard

Hi - I installed the latest atoti 0.5.5 version (with the Hetal's brilliant help) and have a licence issue:
(atoti0.5.5) PS C:\Users\Xavier> python -m atoti.copy_tutorial tutorial
Traceback (most recent call last):
File "C:\Users\Xavier\miniconda3\envs\atoti0.5.5\lib\runpy.py", line 188, in _run_module_as_main
mod_name, mod_spec, code = _get_module_details(mod_name, _Error)
File "C:\Users\Xavier\miniconda3\envs\atoti0.5.5\lib\runpy.py", line 111, in _get_module_details
import(pkg_name)
File "C:\Users\Xavier\miniconda3\envs\atoti0.5.5\lib\site-packages\atoti__init__.py", line 46, in <module>
check_license(_LICENSE_END_DATE, _IS_COMMUNITY_LICENSE)
File "C:\Users\Xavier\miniconda3\envs\atoti0.5.5\lib\site-packages\atoti_licensing.py", line 154, in check_license
raise Exception(output.content)
Exception: Your license has expired, contact ActiveViam to get a new license.

Can someone give me the procedure to change or get a new licence? thanks.

2 replies
TasneemAhmed
@TasneemAhmed
Hi, how can get a result from a running model in colab or AWS by atoti in jupyterlab?
piyuw
@piyuw
Hi, Im getting the following error trying to read a parquet file in Atoti.
image.png