I have very little knowledge in how any of this techy stuff works. At my company we have OLAP cubes in microsoft sql server analysis services These are then fed into Power BI.In Power Bi we have real trouble getting to any transactional data to interrogate, all the reports are set up just to show a GL balance. I’ve requested a drill down option to be able to see the GL lines behind the balance and am being told in the cube they can’t find where the data is stored anything that is being tried is causing the system to run out of memory and crashI don’t have access to view any kind of mapping that takes place from IFS to the cube but generally speaking how is it done?There seems to be 1 cube for the whole GL - would this normally be broken down into smaller cubes? e.g. Sales, COGs, Overheads?In IFS the data I want pulled into Power BI is is stored in “tbwGLQueryVoucherRow2” Just looking for some advice to see if i’m asking for the equivalent of a unicorn or if being able to get GL transa
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
