Is there a way to extract view from cube in TI?

[dharav]

Hello All

I want to know is there a way to extract a view from the cube? I am not asking if there is a view than i can export through asciioutput. I want to extractview from the cube itself without creating any views. We can do manually this by right clicking on the cube and click export data that would open the View Extract window.Now we can extract all cube data in to it if we do not select any views in it. I want to achieve same thing but couldn't able to go through. Is there a function which creates the cube view of all elements in the TI Process? I was looking for viewextract function if it is there, in the reference book 10.1.

Thank You
Dharav

[Wim Gielis]

No, it's not possible. It just works with views, full stop.

PS: can you please change your usage of the expression: "I couldn't able". In all of your posts you write that It should be: "I couldn't be able". Thanks for consideration.

[lotsaram]

Hello All

I want to know is there a way to extract a view from the cube? I am not asking if there is a view than i can export through asciioutput. I want to extractview from the cube itself without creating any views. We can do manually this by right clicking on the cube and click export data that would open the View Extract window.Now we can extract all cube data in to it if we do not select any views in it. I want to achieve same thing but couldn't able to go through. Is there a function which creates the cube view of all elements in the TI Process? I was looking for viewextract function if it is there, in the reference book 10.1.

Thank You
Dharav

Read what you wrote, then read it again. If you're not confused afterwards there you should be. Or at the very least you were confused when you wrote it.

I think what you actually want IS in fact ViewCreate. By default when a view is created and subsets are yet to be assigned for any dimensions the subset is the implicit 'ALL' subset. Thus a newly created view is not "empty" as I think you have assumed but is actually for the whole cube. Which is what you want right?

I would have thought all tm1 developers would know this, or at least should know this!

[dharav]

@ Wim:

Thanks for suggestion and It will be implemented.


@ lotsaram:

I am sorry for it.

Thanks for your input though my question was: can we export cube data without views through TI process/es?

I don't think so we can. I just wanted to confirm it.

We can export manually through view export wizard without creating any cube view. So I got curious to know can we do it same through TI ?

I know the concepts of views and exporting data through it.

Thank you guys for your inputs. Appreciated.

Dharav

[lotsaram]

Thanks for your input though my question was: can we export cube data without views through TI process/es?

I don't think so we can. I just wanted to confirm it.

We can export manually through view export wizard without creating any cube view. So I got curious to know can we do it same through TI ?

I know the concepts of views and exporting data through it.

Well no actually you can't. Although you can manually export a view extract (notice how it's called a view extract, there's a hint there somewhere) without actually selecting or creating a view, if you leave the selection blank then the selected view is in fact a slice of the whole cube with the implicit subset All selected for each dimension. You achieve the same in TI by creating a view but assigning no subsets. Exact same thing, it just requires the creation of an object. (Why this is required of views but not of subsets is however a good point, maybe someone has some insight into that but its beyond my pay grade.)

In terms of your question "can we export cube data without views through TI process/es?" the answer is "Yes of course you can". Just have a think. Regardless of ETL tool in order to export data you need to iterate over a collection, a set, an array or a something. Well in TM1 that something is generally a view. It is the most efficient something. But you could program a series of dimension or subset nested while loops to iterate over a set of cube cells and export data that way. To do so is however generally not efficient as there is no concept with this method of suppressing null values and so there is much more work to do which is why a view is how it's done.

[BrianL]

FWIW: The View Extract functionality in architect/perspectives actually DOES create a view. You can see this by enabling TM1.API=DEBUG in the tm1s-log.properties file and performing the task in the client. You'll see ViewCreate, ViewExtractCreate, and then ObjectDestroy on the view. All showing that a temporary view is being created for you.

[dharav]

Thank you guys for conceptual explanation. it helps. Appreciate it