This generates the data visually in the dashboard and exports to Excel which is the standard for our company at least.
Have you considered generating an additional DW for sale to your users, that puts a lot of the pre-joins together making reporting a lot easier? You fill that data nightly with maybe an emergency reload for a daytime load. We send out an email every morning to the right people on yesterdays numbers giving new YTD totals. From there they pull what they want/need. On Wed, Dec 13, 2017 at 2:40 PM, Paul Hill <[email protected]> wrote: > On 13 December 2017 at 20:10, Stephen Russell <[email protected]> > wrote: > > All of our data comes from a DW and not from the live ERP system of > > record. That system has 280 gigs of Dimension and Fact data that spans > 10 > > years now. > > > > It has taken 2 years since first cubes were presented to the company but > > Power BI went in real fast and we had to hire a FT just to keep knocking > > out more content for users requests. > > Having the data remerged in the cube makes it much easier for naming and > > safety of data. > > > > Power BI isn't the only tool for this. It is CHEAPER overall but we are > on > > prem and not put our data in the cloud yet. > > Thanks Stephen. Can I ask what is a FT is? > We have an extremely good report engine but our customers struggle to > produce the reports they require. > > -- > Paul > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyj6acld2y2b5ago0rvfwp25733gsqfujhqe93juh9u...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
