Skip to Content
0

HANA Calc views with input parameter type Timestamp cannot be accessed from Analysis for Office

Jul 25, 2017 at 09:56 AM

141

avatar image
Former Member

Hello All,

I am not able to access HANA Calculation view with input parameters of type Timestamp created in HANA XS environment in Analysis for Office. I am getting error "No values set for mandatory variable : "

HANA version - 2.00.012.00.1498457145
Analysis For Office Version - 2.4.2.67902
Thanks,
Govind

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jul 26, 2017 at 09:56 AM
0

Hi - Maybe you could share some screen shots? How about updating to the latest patch for Analysis Office? 2.4 SP3?

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Tammy,

This is the screenshot for the error.

And can you please let me know to upgrade to latest version? I tried to download the file for latest version and install but since I am using Office 365, I am not able to install it.

Thanks and Best Regards,

Govind

0

Hi Sri - you work for SAP; if you are on patch 2, I don't understand how you can't install SP3?

Please note I also see you posted on the wiki https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=464702893&focusedCommentId=470289843&src=mail&src.mail.timestamp=1501084812685&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=2c92a04c4fc847d7014fc84a0a443a41&src.mail.action=view#comment-470289843 - and there is supposed to be no cross posting per the site rules. I recommend you remove your wiki comment. You already asked the question here.

Thanks,

Tammy

0
Former Member
Tammy Powlas

Hello Tammy,

These are 2 different topics.

The one I posted here is for Analysis for Office where I am not able to consume HANA calculation views with input parameters. Previously I did not attach the screenshot. Please find it here. cfsdpdemoreportsinputparametererror.png

The comment (rather question) that I mentioned in

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=464702893&focusedCommentId=470289843&src=mail&src.mail.timestamp=1501084812685&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=2c92a04c4fc847d7014fc84a0a443a41&src.mail.action=view#comment-470289843

is about Lumira 2.0 where HANA calculation views created in XS Advanced environment is not available for consumption.

These calculation views that I created in XS Advanced environment are available for consumption in Analysis for office but it does not work if there is input parameter.

Thanks and Best Regards,

Govind

0
avatar image
Former Member
Aug 16, 2017 at 06:52 AM
0

Hello,

Timestamp has to be provided in format of date and time as maintained in the client.

Best Regards,

Govind

Share
10 |10000 characters needed characters left characters exceeded