User Profile

MarcusH

Valued Contributor

Joined 4 years ago

325 Posts195 Likes60 Solutions

View All Badges

User Widgets

Contributions

Re: Where are journal attachments stored in OneStream?
Journal attachments are not saved to a folder in OneStream. You are correct in that they are saved to the table Attachments. They are accessed from the Journals module - the Journal UniqueId is used ...
22 days ago Place Application Build
36Views
1like
0Comments
Re: Syntax to pull entity description where entity NOT the POV entity
The function XFMemberProperty might help you (search this forum for more info). It will probably mean you have to add the descriptions to a Text field though.
2 months ago Place Rules
32Views
0likes
4Comments
Re: Looking for a security report
As T_Kress says there is no report in OneStream that shows a complete picture of where security is applied and what security groups are being used. You will notice that the descriptions on the two p...
2 months ago Place Application Build
9Views
0likes
0Comments
Re: User's Culture
As you have said the core labels of the application is only in English so things like the menu items do not change. User culture is used when you enter descriptions for metadata members in another la...
2 months ago Place Application Build
36Views
1like
0Comments
Re: Filter Members by Security
You can write a custom member list that gets all the members. Read through each member and get the Read and Write groups (I am assuming you are wanting this for the Entity dimension) then check if th...
3 months ago Place Application Build
16Views
0likes
1Comment
Automate Excel workbook refresh
We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views show...
3 months ago Place Reporting
Excel Add In
59Views
0likes
1Comment
Re: Calculate values in different scenarios
You cannot update a different data unit. If you want to update a different scenario or entity for example, you have to change the POV to the scenario / entity that you want to update. This will work ...
3 months ago Place Application Build
19Views
1like
0Comments
Re: Use 2 fields to determine dimension value in datasource
I avoid using any processing of the source data in a data source - it is not transparent, the users have no control and you are losing the audit trail back to the source. None of these might be a pro...
3 months ago Place Workflow and Data Integration
16Views
0likes
0Comments
Re: If I change an account to allow input = false, will my BR still input data into the account?
The allow input flag only stops manual input and import - it has no effect on whether a BR can update something. A BR will update an account regardless of the allow input setting. Set the allow input...
3 months ago Place Rules
44Views
3likes
0Comments
Re: Scheduling an extract of metadata
The xmlExtractOptions object has properties that control what is extracted (eg XmlLoadExtractType.ApplicationDashboards). Unfortunately I haven't found any documentation and intellisense doesn't work...
3 months ago Place Workflow and Data Integration
3Views
0likes
0Comments

Groups

No places to display