OneStream Community

kmd · 10-27-2023

Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file?If it's possible, can anyone provide a brief how-to for setting something like this up? The request i...

kmd · 09-18-2023

Hoping someone in the community might have a solution for this and is willing to share a snippet of code that will enable us to properly 'clear' any data (including zero) from a specific intersection so that we can delete a metadata member.The DM ste...

kmd · 09-06-2023

Hi all,I am trying to find a way to set up a member filter where the member's text 1 field contains the name of an entity.My CV row setup is as follows:E#MyParent.base U1#MyU1Parent.base.where(Text1 contains xxxxxxx)in the above example, xxxxxxx shou...

kmd · 09-01-2023

Anyone have something they use? Seems like OS has never provided a nice little reference like this. Thanks in advance for anything anyone wants to share.

kmd · 07-10-2023

Has anyone else run into the below issue related to Excel Freeze Panes and/or found a solution for it?Unlike exported cube views to Excel, OS does not automatically create frozen panes using Cube View Connections. We have determined that we can apply...

kmd

Wondering why there is no Merge option to begin with? Perhaps this is something that needs to be promoted to ideastream or whatever it's called now

kmd

That's great - thanks. Are you able to provide the name and/or location of that template? I'm wondering if it's just not yet available in our version of OS. Thanks very much

kmd · 09-29-2023

Just adding my 2 cents here as well. This would be a huge feature for our FP&A group but they work primarily in Excel with CV Connections and if they can't easily see the Data Attachment, they will not use the feature. Can't blame them. I can't belie...

kmd · 09-06-2023

Thanks Mike - I agree with your comments. I was hoping not to have to write a BR but looks like I probably have no choice. Thanks again

kmd · 09-01-2023

Thanks very much for letting me know that! 

OneStream Community

User Statistics

User Activity

Can an Excel Journal template be modified to allow upload to multiple periods at once?

Clear unwanted Data in order to Delete a Member

Where Clause usage for Member Filter in Cube View

Looking for list of max character limitations for metadata, including annotations

Losing Frozen Panes setting after refreshing a CV connection in Excel

Re: Workflow - Load Methods

Re: Can an Excel Journal template be modified to allow upload to multiple periods at once?

Re: Data Attachments

Re: Where Clause usage for Member Filter in Cube View

Re: Looking for list of max character limitations for metadata, including annotations