OneStream Community

kmd

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

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

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 · 06-27-2023

Hi all,Trying to delete an unnecessary member from the metadata but it won't delete due to 'existing' data. There isn't actually a value where it says a value exists but OS believes there is data there in currencies that are non-local.I've tried the ...

kmd

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

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

Thanks very much for letting me know that! 

kmd

Hm... I assume this limitation does not apply to other metadata or data source attributes. Just tried to load a file where the Data Source was picking up a member description from the load file and refused to load due to field length (longest of the ...

kmd · 07-12-2023

oh that's a great idea - thank you so much for this suggestion. The option itself seems so non-specific I didn't even think it would have an impact whether on or off. I'll definitely give this a try. Thanks again!

OneStream Community

User Statistics

User Activity

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

Clearing data for a very specific intersection / Data Unit

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

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

Re: Losing Frozen Panes setting after refreshing a CV connection in Excel