Is there a way we can restrict top 10 records in Initial View?

[former_member199763]

Hi,

We have a requirement to restrict top 10 records that are pulled from a datasource.

Could this be doable in Initial View or from Design Studio end?

Noticed it is possible to restrict the number of rows retrieved in Crosstab, but similar option is not available for Charts.

We connect to a HANA view through BICS connectivity, but we do not want to do it in HANA end.

Thanks in advance!

Thanks and Regards.

Ramkumar S

[Former Member · Accepted solution]

Hi Ramkumar,

The initial view does not currently support top n restrictions. What is the reason behind not wanting to do this on the HANA-view side?

Regards,

Sjoerd

[former_member199763 · Accepted solution]

Thanks Sjoerd. The requirement is to have a filter applied to the view and then get the Top N records.

I understand that DS 1.2 cannot send values to Input Parameters of a Calculation View in HANA, which means that I cannot use it for my Top N scenario.

DS 1.2 can send values to Input Parameters in an Analytical View, But I believe that we cannot have a TOP N query setup in a Analytical View.

And so I am stuck here .

Let me know your esteemed thoughts.

Thanks,

Ram

[Former Member · Accepted solution]

Hi Ramkumar,

I don't think Design Studio has any problem assigning values to input parameters on calculation views. I understand your requirement, and this should be perfectly possible. I am in no way a HANA view expert, but maybe     can help you on this one.

Sjoerd

[bharathsap · Accepted solution]

Hi Ramkumar,

Are you using Design Studio 1.2?

With 1.2 you have an option to do dataselection wherein you can choose specific rows/columns that you want to include in a chart.

Refer this vid for more info.http://scn.sap.com/docs/DOC-49300

Regards,

Bharath

[jeroenvandera · Accepted solution]

Hi Ramkumar,

you could try to play with a SQL based calculation view where you apply the following

logic that is explained in this sap academy video : http://www.youtube.com/watch?v=Nt5nDdCNJ2k

if you combine that with adding parameters as explained here http://scn.sap.com/community/hana-in-memory/blog/2013/07/26/implementation-of-wtd-mtd-ytd-in-hana-us...

then i think you should be able to get something going. As mentioned in the second blog you need to be on HANA SP6 for this.

Jeroen

[former_member199763 · Accepted solution]

Thanks Sjoerd, yes currently DS 1.2 allows assigning input parameters to Calculation views through Prompts. You are absolutely right.

I am getting user parameters for my DS application through URL. Now I need to pass these User inputs to the Calc View Datasource without the need for the user to manually enter it in the prompt.

Do you think we can achieve this?

Regards,

Ram

[Former Member · Accepted solution]

Hi Ram,

The function APPLICATION.setVariableValueExt will set the variable value without the need to open the prompt dialog.

Sjoerd

[former_member199763 · Accepted solution]

Thanks very much Sjoerd! you saved me! i'm able to set value for the prompts now silently and app works as expected

Thank you Bharath Ramamurthy and Jeroen van der A for providing insights into Design Studio!

Regards,

Ram

[Former Member · Accepted solution]

This message was moderated.