In my workflow, inside query activity , I cannot able to see the transactions schema from the filtering dimension. But my linking and schemas are all correct.
Can you provide screenshots? There isn't enough detail here for anyone to provide any suggestions. Realistically, we'd need to see the how the activity is configured, how the links in the schemas are defined and the filtering dimensions.