Hi All, I am just having a play with the GL Balance information source and wondered if I can supress rows with 0 balances I currently have the 3 elements below with a row repeater of account There seems to a few account that has a 0 balance. I was wondering if i could exclude that from showing in the report. I have tried setting row filters and cell filters.(Is not Null and not equal to 0 ) doesn’t seem to get rid of them. Is there something obvious I am missing here ? Any advice is appreciated ThanksCameron
Hi All, Is it possible to use the drill down function but point it at a dimension instead of the original info source ? Current report - The report currently uses a custom Info source that has grouped data in the IAL so the drill down wont go further down if I point it to the info source. I am wondering if its possible to point the drill down function to the Dim showing the same columns just without the grouping ? When I have tried to do this - I set up the custom dimension connections and it seems to wipe out my information source in my report as if there was a failure of the connections. Any advise would be appreciated ThanksCameron
Has anyone come across a way of using a wildcard (‘%’ OR ‘*’) in the report Parameters so the user can select all without having to type the individual values? They may need to run the report with one value in the parameter or with no filter so it gets everything pulling through. Any advice is appreciated. Cheers
Hi Everyone, I was wondering if anyone else has come across issues when creating custom information sources and dimensions. When ever i create one from an IAL i find the filters in business reports utility don’t seem to work and i end up filtering my fields in the IAL before converting it to info source. If anyone else has a solution or idea for me to try please feel free to let me know. ThanksCameron
Already have an account? Login
No account yet? Create an account
Enter your username or 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.