Sage 100

 View Only

  • 1.  Business Insights Explorer Views

    Posted 01-16-2019 17:21
    Is is possible to create custom views that can be used with Business Insights Explorer?  TIA

    ------------------------------
    John Leonard
    President
    JLA Consulting
    Metairie LA
    504-835-9639
    ------------------------------


  • 2.  RE: Business Insights Explorer Views

    Posted 01-17-2019 01:11
    If you mean can you create NEW views where you join your own tables (and SQL views like Sage 500) then No. It does require an MD. Having helped create BIE views for J/C, I can say the developer tool is certainly interesting but not really designed for complex views if that's what you're after.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 3.  RE: Business Insights Explorer Views

    Posted 01-17-2019 09:27

    Hi Alnoor,
    You might be a good one to ask about BIE. 
    My experience is that it never quite made it as an ad-hoc data query tool for Sage.  The separate Header/Detail structure is a PITA.
    In the 4 years I was out of the Sage world, it doesn't seem to have changed much.
    Do you have any different insights?
    I usually use excel queries since they are so much more flexible. Especially with Power Query & Power Pivot, which I'll be teaching at MOTM :)



    ------------------------------
    Clark Walliser
    Senior Consultant
    DSD Business Systems
    San Jose CA
    Clark
    ------------------------------

    Original Message


  • 4.  RE: Business Insights Explorer Views

    Posted 01-17-2019 14:02
    Hi Clark,

    You are correct it is still not an ad-hoc query tool. You have to use a pre-defined view and do whatever you can with it. You can't see data past the primary and secondary tables. Also, if you have any need to bend, slice, dice, cube, customize the data in any way beyond what the views provide you, then just like you said Excel with Power Query and/or Power Pivot is the way to go. Very very glad to hear you're teaching it as MotM pre-conference. Way to go!

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 5.  RE: Business Insights Explorer Views

    Posted 01-17-2019 10:24
    Thanks!

    ------------------------------
    John Leonard
    President
    Metairie LA
    504-835-9639
    ------------------------------

    Original Message


  • 6.  RE: Business Insights Explorer Views

    Posted 01-17-2019 14:08
    I've always skipped this tool because 80% of the time the customer sits down and says - well what about looking at the data THIS way... which suddenly for some reason you can't do. It seems like SI or some other BI tool is the best choice for new functionality.

    About the only <g class="gr_ gr_322 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="322" data-gr-id="322">time</g> I seem to get dragged into this is when the customer sat down and created their own views. Admittedly the feature does work it just always seems I get to the brick wall very quickly.

    ------------------------------
    Wayne Schulz
    Schulz Consulting - Consultant
    Schulz Consulting
    Glastonbury CT
    860-516-8990
    http://www.s-consult.com
    ------------------------------

    Original Message


Related Content