Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the follow data model
Fact
-------
InvoiceType
InvoiceDate
LinkKey
InvoiceHeader
...
LinkTable
-------------
LinkKey
RepKey
ManagerKey
BudgetRepKey
BudgetMgrKey
...
RepTable
-------------
RepKey
RepName
...
ManagerTable
-------------------
ManagerKey
MgrName
...
InvoiceLines
-----------------
InvoiceHeader
LineNo
Item
Qty
Amount
InvoiceType has values Invoice, ReturnInvoice, Budget, MonthlyAdjustments (the adjustment invoices have no Rep information but tied to an item in the InvoiceLines)
Invoice, and ReturnInvoice, and Budget are all tied to a Rep and hence to a manager. Section access works beautifully for them and reduces data. However, when someone who is not a rep nor a manager, but an executive who should be able to see all data, for some odd reason all my Monthly Adjustments invoices disappear.
I don't understand why. Is it because they have to LinkKey and hence no record in the LinkTable?? I am thinking that shouldn't matter when I denote InvoiceType in the reduction field with a "*". Am I missing something? Does Section Access require all fields to be connected and supported on reducing fields? That wouldn't make sense either. Any assistance is greatly appreciated.
Check that under Settings > Document Settings > Opening (tab) > Initial Data Reduction Based on Section Access is checked.
Hi,
I see several things, first and most important is that Section Access actually works prompting user and password (or whatever) and reduces data.
Starting with that:
Hope all the above makes sense and helps.
Miguel