Forum Discussion

hoaphan's avatar
hoaphan
New Contributor III
4 years ago

Excel Load Data source (fixed files data source) does complex expressions works ?

Hello I've tried to load my excel file through the data source fixed files with a complex expression on the time dimension, and i think it doesn't go through the complex expression at all so i'm won...
Parsing
  • ckattookaran's avatar
    ckattookaran
    4 years ago

    You can do the following, create a parser rule and then use it like the following.

    SI#::[GetUserName]

hoaphan's avatar
hoaphan
New Contributor III

Could you please let me know how can i use a business rule for an excel load, where do you put the BR, in the excel template? because in the data source it doesn"t work 😕 what's the syntax please ? 
Other question, what type of BR do you create ? a Parser one or an XFBR String ? 
Thanks a lot for your help 🙂

Koemets's avatar
Koemets
Contributor
4 years ago

You reference a BR from any particular dimension, in Logical Operator functional area.