Can one, how does one create/build a Cube based on a view or views???

Folks --

I appreciate any info and assistance. Thanks, in advance.

Can one, how does one, create a Cube based on a view or views in SQL
Server??? If there's nothing in a view, then how would a Cube build?
How could one use a view as a fact table if the view shows zero
records?

I do understand how to build a virtual Cube over two other Cubes. I
understand how to build a Cube off a flat file table in SQL Server. I
suppose I could creat a view, run the view, populate a new table with
that data, and then build a Cube on that???

But how could/would one build a Cube off of one or more views?

Many thanks.

Pete

Pete Hohenhaus
Kirkland, WA, East Side Seattle, USA

A view can be the fact or dimension source. The view does need to return
data to populate the cube or dimension, just as with a table. Just select
the view as you would a table from the list of source objects provided by
the AS wizard.


"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote

Here's an interesting twist... Analysis Mgr requires that that fact table
(or view) have at least one row. But, you can build cube, delete row (or
change WHERE clause in view), re-process cube. Then you have an empty cube
which you can use as blank modeling space.

tom @ the domain below
www.tomchester.net


"Jim Kaiser" <jkaiser-no-spam-att-henwoodenergy.com> wrote

Tom --

Sorry, I must be thick witted on this one. I don't quite understand
what you said. I get the following error message when I try to use a
view as a fact table:

Error(-2147221425): The object structure is not valid (Fact table size
cannot be 0); Time:9/14/2003 4:05:16 PM

Any further direction would be helpful.

Thanks again.

Pete


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Hi Tom --

Thanks but I just don't get it. Every time I attempt to use a view as
a fact table it gives me an error message saying, of course, a fact
table can't have zero rows.

Any other guidance?

Much obliged.

Pete


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Analysis Manager won't allow a cube to be built if the fact table (physical
or view) has no rows. But if you happen to want an empty cube, you can build
it, process it, delete the data, then reprocess.

tom @ the domain below
www.tomchester.net


"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote

Actually , you just have to pretend that the fact table is not empty.
In the cube editor just set the 'Fact Table Size' property (Advanced
tab) manually to 1 (or anothing other than 0).

Thomas

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Big thanks, Guys!!!

thomasgreuel (AT) hotmail (DOT) com (Thomas) wrote in message news:<7f43db9d.0309150053.6ad20579 (AT) posting (DOT) google.com>...

I believe you'd better to check the underlying table/view is not
empty first and then go ahead to process the cube or partition.
Otherwise you will

face trouble when later you want to incremental processing. See the post
of http://dbforums.com/showthread.php?threadid=584920



Originally posted by Thomas


--
Posted via http://dbforums.com