Skip to Content
avatar image
Former Member

Find information on Calculation view ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 23, 2017 at 07:34 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 18, 2017 at 11:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22, 2017 at 12:24 PM

    Hi,

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

    Best regards

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded