860
At our company our users tend to use this report a lot and its slow as molasses. Is there way to do this with the analysis cubes? Ive seen examples of calling a series of stored procedures to get this data, but have not seen anything using SSAS or MDX.
*This post is locked for comments
Well, if anyone would have such a report it would be Victoria Yudin. She is one of the best of the best GP people on the planet. If you can pull your data off the production server and do nothing but reporting off another that would be the way to go. The trick will be pulling the transactions by a particular date. There are a lot of dates involved in that report.
Thanks. Currently I have a stored procedure that basically wraps a few stored procedured (rmHistoricalAgedTrialBalance) in GP to pull the information out and into another Db, then building a report from there is simple. However, what Im after is whether or not this would still be needed, as the historical aged trial balance will pull the data as-of a specific date. I'd really like to decommision this custom solution, if this same
fyi, I found an interessting dicussion on another forum that is related. As you mentioned, it is possible it seems.
See, posts #5 and #6 by Amber and Kimberly.
https://www.gpug.com/communities/community-home/digestviewer/viewthread?MessageKey=66df241e-d762-4e6d-b026-02e70ef341bb&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=digestviewer
Analysis cubes allows you to drill into the data. It is not meant to be a reporting tool with which to build a trial balance of any kind. I would suggest you set up SQL log shipping to another server and have them use that for reporting.You never want user run disk intensive reports on your production server during normal working hours.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (