Skip to Content
author's profile photo Abhijit Ingale
0
Abhijit Ingale

Lumira on ECC Infoset - Help required

Posted on Aug 04, 2016 at 05:47 AM 63 Views

Hi,

I am using SAP Lumira 1.31 to connect to ECC Infoset using ECC 6.0 JCO driver. I have around 20 fields selected for Output in ECC Infoset. In ECC on execution it shows only the selected output fields. But when I am acquiring the data in Lumira using the same Infoset, I am getting 1000+ dimensions and 700+ Measures and not just the fields selected for output in ECC infoset.

I had to modify the SQL in acquisition step to include only the fields required for analysis to get rid of unwanted fields.

Please help me with following -

1. Why would Lumira return all fields from all the tables used in ECC infoset instead of returning just the ones selected for output in ECC infoset?

2. When the storyboard created on ECC in Lumira is published to Lumira Server for BI Platform, how data refresh can be scheduled on BI Platform? Would it store the ECC connection information on Lumira Server for BI Platform when it gets published?

3. Any way of applying Row level security for such storyboard when accessed through Lumira Server for BI Platform.

Please help.

Thanks,

Abhijit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Varun Anand
    Varun Anand
    Posted on Aug 04, 2016 at 06:56 AM
    2

    Hi Abhijit,

    You would want to refer to the following blog, How to use classic SAP Query Infosets as a Data source in SAP Lumira

    1) In Lumira, the dimensions and measures are controlled in the front end tool and the data is controlled by the backend. That is the reason you needed to modify the query in the Lumira SQL editor to only acquire the required dimensions and measures.

    2) You can right click the Lumira document and find the schedule option in the BI platform. And you can refer to Refresh and Data Source support for Lumira Document in SAP BI

    3) Row level security is something which is controlled in the backend system and this gets reflected in the Lumira Server for BI platform.

    Thank you,

    Varun Anand

    Add a comment
    10|10000 characters needed characters exceeded

    • Abhijit Ingale Ludek Uher
      Aug 23, 2016 at 04:24 AM

      Ludek,

      Thanks for your response.

      You are right that I have not tried this out yet. We need to suggest approach to one of our customer before they proceed with their implementation. That is where I was looking for clarification if row level security can work for Lumira on ECC the way it works for other data sources e.g. BW or HANA.

      Regards,

      Abhijit

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.