User Profile

MarcusH

Valued Contributor

Joined 4 years ago

320 Posts192 Likes58 Solutions

View All Badges

User Widgets

Contributions

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...
5 days ago Place Reporting
Excel Add In
9Views
0likes
0Comments
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 ...
7 days ago Place Application Build
8Views
0likes
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...
14 days ago Place Workflow and Data Integration
8Views
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...
15 days ago Place Rules
36Views
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...
25 days ago Place Workflow and Data Integration
1View
0likes
0Comments
Re: Transformation Rule Mystery
You can get some strange results when using a range map and the source has a mixture of numbers and characters. The comparison of the start and end values is treated alphanumerically which means that...
2 months ago Place Rules
109Views
2likes
0Comments
Re: Bypass Characters in Transformation Rules
I think you could do it with a Mask map: ???* as the source with * as the target should work in theory but I have had mixed success when using * as the target. If that doesn't work you could creat...
2 months ago Place Application Build
19Views
2likes
2Comments
Re: Lookup Transformational rule UNDO
The TransformationEventHandler is automatically executed whenever the Load and Import process is executed. Create a new Business Rule and select Transformation Event Handler from the list if you do n...
2 months ago Place Rules
9Views
1like
1Comment
Re: Lookup Transformational rule UNDO
The TRX load process does only very basic checks on the records being loaded. I have had instances where the TRX file is loaded without any errors but the maps do not appear. When I looked at the dat...
2 months ago Place Rules
39Views
2likes
5Comments
Re: is there a way to check the total value on each account in the staging?
Derivative Rules are the normal way of aggregating source data records. The usual way of using them though is to map the net position ie you aggregate the source into a single record which then gives...
2 months ago Place Rules
13Views
1like
0Comments

Groups

No places to display