Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

Connector rule - Drill back on dimension using a business rule logical operator

Hi, in a connector business rule, when a dimension has a business rule logical operator, is there a better way to build the SQL drill back query than reverse engineer what the business rule is doing...
  • JackLacava's avatar
    2 years ago

    OneStream doesn't have a "pre-Stage" area, no. I mean, most systems don't even have a Stage area 🙂

    If you want to keep track of "pure", pre-transformation values, you have to do it explicitly yourself at Import time. You could do that by mapping original values into an Attribute or Attribute Value field, effectively copying it. When you drillback, you could then look up that AV field to retrieve them. You can do the same for any other identifier that you plan to leverage for drillback purposes (rowIDs or whatever).