I see the question now.. well, what lists on "Query" tab is tables not
cubes. You have 10 cubes, but they all from one table. So for analyst (who
don't care about cube), all they know is there's a table called test1,
he/she can query.

And yes, you can drop the test1 cube which does not contain any filter.

On Tue, May 12, 2015 at 11:30 AM, dong wang <[email protected]> wrote:

> 0, I have a fact table named test1
> 1, I build a cube with no filter and the same name 'test1' as that of the
> fact table, the cube 'test1' is shown on the "Query" tab
> 2, then I build 10 little cube with FILTERs(different where) and with
> different names based on the SAME fact tables test1, the names of 10 little
> cubes seperately are : test1_sub1, test1_sub2, test1_sub3, ... ,
> test1_sub10,  after all of the 10 cubes are built successfully, it shocked
> me a lot, I cannot see any test1_subx under "Query" tab
>
> however, when I do some queries, I can find the log shows that it hit the
> cube correctly which I want with the info "Realization Names:", which seems
> satisfy what Luke talked to me last time, but I still wonder, can I drop
> the above cube "test1", since I only want the query to hit test1_subx
>

Reply via email to