Skip to Content
avatar image
Former Member

how to access analytic views created in HANA using IDT

Dear SCN,  I have created analytic view using HANA, Am unable to see the column views created for the same under "_SYS_BIC" schema in IDT but the same is visible in HANA Studio. Can you please help me understand how can i consume these views? And if they are any limitations?

Regards,

Krishna Tangudu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 22, 2012 at 06:40 AM

    Hi Krishna

    Can you mention the version of BO IDT  you are using is it BI 4.0 FP3? , also please tell us whether you are facing any error or just not able to view the column views wrt to the analytical views in HANA.

    Thanks

    Santosh Varada

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2012 at 06:02 PM

    Hello All,

    Thanks for your replies.

    I have created a analytic view named "AN_TEST1" in hana studio. Am able to see the column view under _SYS_BIC schema in the studio as shown below:

    And after creating a JDBC connection using IDT, this is what i see under _SYS_BIC schema using IDT as shown below:

    Please help me what to choose from here to continue to buld my univers. i can see all the other tables except "_SYS_BIC"."package/AN_TEST1"

    Regarding Version am using : IDT Version: 14.0.2.v20120322-0657 i guess this is FP3. am i right?

    Hoping my question is clear now. Please help me in this.

    Regards,

    Krishna Tangudu


    AN_HS.png (5.2 kB)
    AN_IDT.png (14.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Krishna,

      Were you able to resolve this issue? I am seeing the same behavior when trying to create a Universe using IDT. I am on BOBJ 4.0 FP 03 SP02 and using SAP HANAOne instance (AWS).

      Thanks,

      Gaurav

  • avatar image
    Former Member
    Jul 23, 2012 at 08:41 AM

    Hi Krishna,

    I have noticed that the Column views are not shown in the IDT in same order as of HANA Studio. So you can scroll down a bit and you can see the proper view hiding down below.

    /bikas

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2012 at 10:04 AM

    Hello Krishna,

    You will definitely have column views generated if analytic view's activation was successful.

    If you have Created 'AN_VIEW_1' under the package 'pkg1', you will have the column view

    "_SYS_BIC"."pkg1/AN_VIEW_1"

    If you want to find the actual column view name for the view that you have activated,

    Do a data preview in SAP HANA Studio -> Click on 'i' button near the refresh button and you can see the whole SQL select query generated upon the column view object and you can derive the name of the view out of the same.

    Thanks and Regards,

    Sathish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2012 at 11:56 AM

    Hi,

    You should be able to see the coloumn views under _SYS_BIC. If not, could it be the authorisation on the user (if not SYSTEM) that you are using to connect the IDT to HANA? If it is the SYSTEM user that you are using it comes with read access on _SYS_BIC.

    Thanks,

    Anooj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2012 at 07:20 PM

    Hello guys,

    I tried all the things , but still am unable to see the views. Can anyone help me to know if we have any pre requisites to be done to be able to see HANA Views using IDT?

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Krishna,

      I have faced a similar issue with the SCHEMAs. I was accessing different HANA systems from different HANA Studio Rev clients (25 and 28). I could not see the schemas created in Studio 28 in the Studio 25.

      Do you have similar context here?

      /bikas

  • Dec 01, 2012 at 10:37 PM

    Hi Krishna

    Did you find a solution to this issue.

    I have the same issue and I tired a new connection but that is not helping.

    Poonam

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2013 at 04:56 PM

    When selecting the table from _SYS_BIC schema there will be two tables which will be there with same name (one with olap suffix and other without olap suffix - screenshot attached here for the same).

    Can you please select the one without olap from IDT and see if you are able to see the calculated attribute?

    Please note that the table names will not appear in same order so you will need to scroll through the whole list or use the search option.

    Let me know if this solves the issue

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2015 at 05:41 AM

    Hi

    Are you still facing this issue?

    Try to create a new connection.

    In my case I had existing universe and in HANA one new calc view created and I had to bring the newly created view into IDT. But unfortunately I could not see the newly created calc view under _sys_bic. (but it is available under _sys_bic in Hana). So I have created new local connection in IDT under the same universe and changed the connection to the newly created local connection. That's it. newly created HANA view available in IDT.


    Thank you!!!


    Regards,

    Mathivanan M

    Add comment
    10|10000 characters needed characters exceeded