How to write from a SQL query into a cubeview
Good Day I am new to OneStream so forgive me if this question and the answer should be known but I have created a SQL table with values and I would like to take those values and write them to a cub...
Forum Discussion
Hi RehaanAbdulla , how about dropping that SQL into a Data Adapter, then assigning that Data Adapter to a SQL Table Editor or Grid view component, then you can display the resulting table in one of those Dashboard components. Not sure you are demonstrating a solid business case trying to squeeze a data table into a Cube View. The name Cube View is what it is, it is a view of the Cube data. Not a view of relational batch records. I could be wrong, but if it were me I'd go a different route for the display of that batch record data.
Hope this helps.
Hi MikeG
So we have created it as a SQL Table and made it into a grid view. However the reason for me wanting to move the the data on the SQL table to the cube view is that each month they would make changes on the SQL table and then it must show up on the cube view or if they dont make any changes then if could be transferred to the cube view as well.
Each month the cube view will not carry the values it had the previous month and so the SQL table will carry it however the users will need to see it on the cube view.
Regards
Rehaan