DataBrewery / cubes

[NOT MAINTAINED] Light-weight Python OLAP framework for multi-dimensional data analysis
http://cubes.databrewery.org
Other
1.49k stars 313 forks source link

Question: export/save the cube(s) from a workspace #485

Open T-Born opened 4 years ago

T-Born commented 4 years ago

Hi, First, thanks a lot for developing cubes! I would really like to use the framework and participate in the project, if I am going to use cubes in production. Currently we create cubes manually with VisualStudio for each new version of data. Because data is created with Python I would like to automate the cube creation in Python as well. Our CubesBrowser has come to age but will have to be used for about the next 2 years by our Customers. So my major interest would be the creation and deployment of the cubes. (I will certainly play around with the browsing capabilities to evaluate the replacement of our current viewer.)

Now to the Question: My created cube works so far, but is not saved in the registered store. Is it possible to save the cube to a certain database or does it only live in the active workspace?

code:

ini = configparser.ConfigParser()
ini.read("edges_cube_config.ini")

workspace = Workspace(config=ini)

ini (edges_cube_config.ini):

[store]
type: sql
url: sqlite:///C:/test/cubes/TestDB.sqlite

[models]
main: edges_as_facts_model.json