Skip to Content

Hana Analytic Views not visible in BO - Data Foundation

Hi,

I have created an Analytic View under my own package. When tried to access this A.V in Data Foundation in BO, Iam not able to view this A.V under my package. Have gone through SDN where it shows, in order to access the A.V in Data Foundation the Views should be under _sys_bic schema.

I don't find my Views under _sys_bic schema. So do I need any special authorization rights? Or how do I make the views available under _sys_bic schema? Is it mandatory that views to be accessed in Data Foundation should be under _sys_bic schema? Any Help?

Regards

Sudhakar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 02, 2014 at 05:02 PM

    Hi Sudhakar,

    For any View(Attribute, Analytic or Calculation) that is created in HANA, a Column View is created inside _SYS_BIC schema.

    All reporting tools access these Column Views for reporting.

    Check if you have access to _SYS_BIC schema, if you have access to the schema then go to Catalog_> Column Views and check for a Column View that has name similar to your created HANA View

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2014 at 05:40 PM

    Hi Vivek,

    Thanks for ur reply. As you said iam able to find the AV in _sys_bic schema. Iam able to view the tables under my own schema in DF layer. Under _sys_bic schema in DF layer im not able view the A.V that iam able to see in Hana Modeler.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2014 at 01:31 PM

    I have the same problem with views created in a HANA Live system. The data preview within HANA studio returns data, but the view is not visible from Analysis for OLAP, Analysis for Excel, Design Studio, or IDT. Any help you can give will be greatly appreciated.

    Thanks,

    Rob Frye

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sudhakar,

      I am not sure whether your query is relevant still. But the solution, as Robert pointed out, is this.

      For any Calculation or Analytic View to appear in a Front End Analytic Tool, such as even SAP Lumira, the View in SAP HANA should be categorized as "CUBE" in the property "Data Category".

      I faced similar situtation too once. 😊

      Best regards,

      Akhil

  • Oct 07, 2014 at 09:10 AM

    Hi Akhil,

    As Robert said, After changing the property AV's worked. Robert / Akhil , your anwers where helpful.

    Thanks a lot.

    Regards,

    Sudhakar

    Add comment
    10|10000 characters needed characters exceeded