Forum Discussion
10 Replies
- OSAdmin
OneStream Employee
Originally posted by Jeff JonesMark,
Currently this would require a rule to be able to check if a report is going to have any intersections inside of it and if it did not return a value for an intersection that you define, you could skip it.
There is an enhancement request in place for this functionality with development.
Once the rule is imported you would call it in the book like this:
If BRString(GetCellValue, GetCellValue, accountMember = YourAccountName, entityMember = YourEntityName) = “TRUE”
The highlighted section is where you define the name value pairs. These could be parameters, sub vars, loop variables or hardcoded values.I have attached a rule example for you. You would need to rename it to .xml and then import it into your application.
?
- OSAdmin
OneStream Employee
Originally posted by Mark WilliamsThanks for the reply. Sounds easy enough, did you forget to attach the file?
- OSAdmin
OneStream Employee
Originally posted by Jeff JonesMark,
Looks like the community will not let me attach the XML File, even if I rename it to .txt, I will have to e-mail it to you.
Jeff
- JPierluissiNew Contributor II
Hi Jeff,
I realize this is an older post but can the solution for this be e-mailed to me: joseph.pierluissi@sonesta.com
- OSAdmin
OneStream Employee
Originally posted by Donald HobbsHi,
Can I please also see this example rule?
Thank you
- OSAdmin
OneStream Employee
Originally posted by Brett AtkinsonHi,
@Jeffrey Jones may i get a copy of this xml emailed to me as well? batkinson@benchmarkglobal.comThank you.
- OSAdmin
OneStream Employee
Originally posted by Sara BioqueHi all.
@Jeffrey Jones , thanks for the post. May I also get a copy of the xml?my email: marcos.concari@nova-praxis.com
Thanks in advance.
- OSAdmin
OneStream Employee
Originally posted by Campbell ReddickHi Jeff
Will this also work for Excel based books? If so may i get a copy of the BR and few more instructions on where to call this BR.
Thanks
- seanglyNew Contributor III
Hi,
Where you able to get a working solution for your excel based book?Regards,
- OSAdmin
OneStream Employee
Originally posted by Campbell ReddickHey Jeff
Can you send me the code you tried to attach to this ticket? Also, where do I call it in the book builder?
Thanks
Cam
Related Content
- 3 years ago
- 2 years ago
- 2 years ago
- 4 months ago