Data Reader Limitations

I am loading my data from SAP Function Module. And my records are 35,000. While loading it in data readers, it is not working and showing previously loaded records only. Can anyone please suggest me such way for this problem?

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Dear Vaishali Shah!

     

    It would be helpful if you could provide some more detail.

    Which function module are you using in what way? 

    Do you use the Theobald Connector - which one?

    What is your Board version?

     

    Kind Regards,

    Helmut

  • Hi Helmut Heimann,

     

     

     

    I am using z-function module related to sales data. I am using SAP Connector.

     

     

     

    Regards,

     

    Vaishali Shah

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Vaishali,

     

    since you're using a customer defined module I can only make assumptions...

    Does this module have any row limit?

    What happens if you try to load an SAP SD table like VBAP for instance directly using the Theobald table extractor - will you still face the issue of any row limit? Then this would lead me to the assumption that the connection settings limit the number of rows.

     

    Kind Regards,

    Helmut

  • Hi Helmut Heimann,

     

     

     

    Connection limit in board side? If yes then how can we can the limit of fetching records in board?

     

     

     

    Regards,

     

    Vaishali Shah

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Vaishali,

     

    no, not on Board's side - check the connection settings in your Theobald connector.

    And, please, check the outcome of a simple table connection (like the above mentioned VBAP).

    And: which Board version are you using?

     

    Regards,

    Helmut

  • Hi Helmut Heimann,

     

     

     

     

     

     

     

    See, here I am getting 34,283 records successfully. But after that when I will load data in my data reader, I will show me previously loaded data.

     

    It seems like data reader is not loaded but I am loading it again and again and still it’s not reflecting here.

     

     

     

     

     

     

     

    Here, date should be 17/01/2020 and records should be 34,283.

     

     

     

    Can you please help me to solve this issue.

     

     

     

    Thanks in advance.

     

     

     

    Regards,

     

    Vaishali Shah

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Vaishali,

     

    your first image only displays the number of valid records, the image is cut off when it comes to discarded records. Have any records been discarded? If so, check why and check the log-file and act accordingly.

    The next thing is: please check whether all dimensions in your source data are available in your target cube. Maybe the data is aggregated by Board because you've omitted needed dimensions.

    And please check whether your source data contains any NULL values.

     

    Kind Regards,

    Helmut

  • Okay. Thanks.

     

     

     

    I need another help. Actually I want to login Board Mobile application in IPAD. For that it is asking server address.

     

    How will I get this?

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Vaishali,

     

    that's a different context and you should open a new thread for that question.

    First of all, it would be more feasible using the Board Web frontend - even on an iPad.

    For more information on the mobile topic please refer to our help page Mobile 

     

    Kind Regards,

    Helmut