Sage 100

 View Only
  • 1.  In Providex versions of Sage 100, Sage created vie

    Posted 10-16-2017 14:40
    In Providex versions of Sage 100, Sage created views for us. However, in the Premium versions, these views have disappeared. I know I can manually create views in SQL, but does anyone know if this is just hidden somewhere that I haven't found yet. I thought Sage created these views to make Business Insights Explorer work efficiently (insert roll of eyes here). BIE still exists in SQL/Premium, but the view are gone. Any ideas @Sage100Routine


  • 2.  RE: In Providex versions of Sage 100, Sage created vie

    Posted 10-16-2017 15:06
    I think the views are only used for BI reporter (not the dashboard or the explorer views). And looking at my Premium install there is no Business Insights Reporter. So, I don't think they are hidden anywhere. I just think they dont exist in premium. I couldn't find them anyways.


  • 3.  RE: In Providex versions of Sage 100, Sage created vie

    Posted 10-17-2017 11:01
    Confirming that BI Reporter and its views by design do not exist in Premium. Also if you upgrade to Premium from Std/Adv and had further modified the views via BI Reporter, Migration won't copy over the views to Premium. It's been this way since the very 1st version of Premium.