B1H user model as datasource in interactive analysis designer

[former_member230931]

Hi All,

Has anyone been able to publish a user created Hana model to use in interactive analysis with excel reporter like report creation tool. When I publish a new model to SAPb1 its available in interactive analysis only as a pivot table option. Screen below shows the tool I want to use (this not the pivot table option):

thanks

[julie_jamieson2]

Hi Dick,

Did you ever figure this out? I am on the same journey at the moment as a newbie to Hana and am about 3 weeks in to trying to track down ANY information on this - struggling to create my own view for Excel report

Thanks

Julie

[former_member230931]

Turned out that you need to end the top level calculation view name with Query

for example SalesAnalysisQuery

[Former Member]

Dear Dick

I saw youtube

sap business one hana - YouTube

It seems like you that draw the data out first.

and then do the pivot table later.

You study by yourself?

Regards

Edmund

[former_member230931]

thanks but I'm asking a very specific question here from people who have experience...which is not covered in docs