How to identify the cubes with the same name but under different package

[Former Member]

Hi,

As you know, we can execute MDX statements directly in HANA studio.

In my case, I have 2 cubes, analytic view, under different packages, but they have the same name.

When I execute a simple MDX statement which just use a few field of the cube, I met an error which says that the cube is ambiguous.

So, my question is that how to identify the cube?

Regards

Pengcheng

[FabioV]

I solved using the

SET 'MDX_CURRENT_CATALOG' ='<catalog>'

instruction before the

MDX SELECT

in the SQL Console

[Former Member]

You probably need to specify the location difference.

EG in the SQL editor you would call a view output with the following:

EG SELECT * FROM "_SYS_BIC"."package.subpackage/analyticviewname";

_SYS_BIC is the schema where activated views are generated for report viewing.

Have you tried specifying the location in your MDX to all the column view of the activated analytic views in teh _SYS_BIC schema?

[Former Member]

Hi Pengcheng,

maybe an option is to use EXCEL MDX to get the data from the correct cube and check the MDX statemente from there with tools like this:

http://olappivottableextend.codeplex.com/

or

http://sqlblog.com/blogs/marco_russo/archive/2007/01/18/display-the-mdx-query-of-an-excel-2007-pivot...

Hope that helps.

Best Regards,

Marcel

[Former Member]

Hi,

How are you refering to your analytic views within your statement? Are you using "_SYS_BIC"."<package_name>/<view_name>"?

It probably would be easier if you copy pasted the statement here.

Thanks,

Anooj