cancel
Showing results for 
Search instead for 
Did you mean: 

Find information on Calculation view ?

Former Member
0 Kudos

Hello,

I 'm trying to create a procedure which can check information on calculation view.

For this purpose I would need to know if calculation view:

is cross client ?

if there is a keyfigures ?

i also need to get commentary and cardinality on every node and to know if the node is rename.

Is there a way to get those information ?

I found interresting table on SYS.VIEW but most of them are empty.

If you have any idea please share with me,

thanks in advance,

Etienne

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

Hi,

You can get information on Calculation Views in BIMC tables in _SYS_BI Schema as depicted in the below image.

If you want to get the information via sql or in a procedure, you could query these tables but the uer should have select prvileges on the _SYS_BI schema or respective tables.

D039507
Advisor
Advisor
0 Kudos

Hi,

you will also find a lot of information regarding the metadata of a calc. views in these tables:

Best regards

Thorsten

0 Kudos

Hello Etienne,

There is a option called 'Auto Documentation' which will have all the details mentioned in your question.

Right of the click on the view and you will find it.

Please check.

Thank You,

RP