Skip to Content
0

Find information on Calculation view ?

Jun 22, 2017 at 08:19 AM

90

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Anjali Chimnani
Jul 23, 2017 at 07:34 PM
1

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.


image.png (14.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 18, 2017 at 11:14 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Sep 22, 2017 at 12:24 PM
0

Hi,

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

Best regards

Thorsten


sys-repo.png (31.5 kB)
Share
10 |10000 characters needed characters left characters exceeded