About former_member197081

former_member197081

Hi Experts, I am trying to use the APPLICATIONUSER in a graphical calculation view to filter a table based on the user who is running a query on the view. But I am not sure how to, as I do not have access to Web IDE or BAS. I am currently on HANA ...

former_member197081

We are currently using HANA 1 sps 12 and SPARK controller to create virtual tables and access the HIVE data in HANA. The problem is we have some SC2 table we want to archive in HANA for which we need full CRUD operation. We have converted a few of th...

former_member197081

Hi All. I was optimizing data model (calculation view) which is processing a huge amount of data and is taking a lot of time to execute. I analyzed and fond that I can use some Input parameter to restrict the data in lower level that filtering it i...

former_member197081

I want to count the number of one column in Graphical calculation view. The same is available in Analytic View. But I need it in Calculation View, please sugest some workaround.

former_member197081

Hi All, I am trying to replace a specific value of a column and put it in the where clause. Usually I would create a calculated column and put it in filter. But as I am creating a DB view in catalog folder, I don't have this option. The calculated ...

former_member197081

Hi Florian,Yes, I thought about the same. But I wanted to avoid adding a new Inner join and use a filter expression instead. But looks like without webIDE, I am stuck with this method alone.Anyway, thank you for your swift response as always. Regard...

former_member197081

Hi RB,I am also facing the same issue of double quotes, but I am using the Hadoop(ODBC) driver and I am able to create virtual table but not able to query them. Could you please let me know, how you resolved it? or what is the alternative approach yo...

former_member197081

Hi Aleks, I know its a really old blog. I landed here looking for a wat to cache data for SDA Virtual table (from Hadoop) to speed up my query performance. Do you have any idea on how to achive it HANA 01 SPS 12?

former_member197081

Hi Florian, Sorry for replying late. The issue was really weird, when I created the same table in sys_bic schema then also it did not work. So I created a new table in its own schema and loaded the records from the existing schema, it worked. Thoug...

former_member197081

I created a sample table in Sys_bic, and changed the procedure to point to the new table and now everything works as intended. But the problem is I can't use it from sys_bic, I have to use it from the original schema. Please help me with what type of...

User Statistics

User Activity

How to use the APPLICATIONUSER session variable in HANA Studio/Web Workbench

How to access HIVE ACID tables using HANA SDA Virtual table?

Plan Viz analysis.

How to use COUNT in Graphical Calculation view

How to put a if statement in where clause?

Re: How to use the APPLICATIONUSER session variable in HANA Studio/Web Workbench

Re: HANA Generic ODBC Adapter

Re: What’s New in HANA 2.0 SPS 00 Smart Data Access

Re: How to create an input parameter to pass another corresponding value?

Re: How to create an input parameter to pass another corresponding value?