About former_member249712

former_member249712 · 02-11-2019

Hi All, I am creating a repository stored procedure in schema SCHEMA_A ,in which i am selecting data from SCHEMA_A. The procedure is created with definer rights. Since it is a repository procedure definer will be SYS_REPO. So,I have given the S...

former_member249712 · 03-08-2018

Hi Experts, I have created a stored procedure which is calling a Calculation view.I need to pass multiple input parameter value but i am not able to do so. I have checked all the blog regarding this but everywhere it is shown by passing the value i...

former_member249712 · 11-08-2016

Hi Experts,Do any of you know how to setup the execution hint in calculation view? I need to setup the “no_use_olap_plan” hint to a calculation view with a parameter value. Not sure, what is it’s combination. Can you help with this? Also, do you have...

former_member249712 · 06-10-2016

Hello Experts, I want to consume HANA Hierarchy in BOBJ Reporting tools. I am unbale to find the Hierachy in Analysis Office 2.2 and 2.3 version.Environment: SAP HANA SP10, Revision 102.4 -> HANA Calculation View with Hierarchy SAP Analysis Office E...

former_member249712 · 06-02-2016

Hi All,I Want to Change the Field Name Dynamically in a Calc View Output as Per My Input Parameter.For Ex lets i have Data Like this for the Temp of Different Cities of india:-TODAY DATACities11_APR12_APR13_APRhyd101214mum121312ban131513Here My Input...

former_member249712 · 01-02-2020

Hi Madan,Could you please elaborate your question and provide some sample data with proper result set in Excel.In between if you want you can try using QUARTER ,ADD_MONTH or ADD_DAYS function.Regards,Anuj Kumar

former_member249712 · 02-12-2019

Thank you so much.

former_member249712 · 10-03-2016

Hi Rithika,If you are looking to pass all the material if you are passing "BLANK" value then i have a different solution to the Same. In that case you need to Give '*' in default constant value and Use IN and MATCH in Filter Expression with Multiple ...

former_member249712 · 06-10-2016

Thanks For the Reply,I saw the thread https://scn.sap.com/thread/3818685 ,We are also Facing the Same Issue.We are Able to see the Hierarchy in MDX for Excel,But We are not Able to do the same With Analysis For Office Version-2.2 and Version-2.3Is th...

former_member249712 · 06-02-2016

Hi Lars,Thanks For Your Reply!!We are trying to built the Lumira Reports On Top Of HANA model.But,We Could Not See Any such Functionality In Lumira Application Tool.That's the Reason We Thought to Design in HANA layer Itself.Kindly Advice...Regards,A...

User Statistics

User Activity

Definer and Invoker rights in HANA

How to pass Multiple Input parameter while calling calculation view inside stored procedure

What is the Execution Hint in Calc view Parameter?

Analysis Office Excel Issue with HANA Calculation View(with Hierarchy)

I Want to Change Field Name Dynamically In Model.

Re: Dynamic Quarter Calculationv view in SAP HANA

Re: Definer and Invoker rights in HANA

Re: Calculation view - No results - when input is blank

Re: Analysis Office Excel Issue with HANA Calculation View(with Hierarchy)

Re: I Want to Change Field Name Dynamically In Model.