![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdVlteHZaM011WTI5dEwyTnVZbXh2WjNOZlkyOXRMMnBwWVc1bmVtaGxibWRxZFc0dk5qVTFOakUwTDI5ZkpVVTNKVUpDSlVKR01pNW5hV1k9LmpwZw%3D%3D.jpg?w=700&webp=1)
声明:原创作品,转载时请注明文章来自SAP师太技术博客( 博/客/园www.cnblogs.com):www.cnblogs.com/jiangzhengjun,并以超链接形式标明文章原始出处,否则将追究法律责任!原文链接:http://www.cnblogs.com/jiangzhengjun/p/4297533.html
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNM05UQXhPRGs0TURVNUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNM05UWTBNalEyTWpVMExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
- 特征值变量
报表运行时,根据给定变量的值对特征进行过滤
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNM05UazROemMxTmpZMUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1EQTRORFkzTnpNMkxuQnVadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1ERTNOamMwT0RJeUxuQnVadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1ETXhNamMwTmpBMkxuQnVadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
- Hierarchy变量
报表显示时可以根据用户选择的不同的Hierarchy来显示不同层次的报表
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1EUTVOVFUwTlRRM0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1EZ3hPRGswT1RZd0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
- Hierarchy Node变量
针对层次的节点值进行滤过的变量,而不是基于某个特征的变量
除对特征值通过特征变量进行过滤之外,还可以通过特征值所属Hierarchy的Node变量进行过滤:
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1USXlNRFU1TnprNExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1UUTRNekEwTURrM0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1UYzVOekV6TlRNNExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1Ua3lNakV6T0RJekxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
- 文本变量
用来替换报表头标题、表字段标题的文本
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1qSXhOelF4TXpJeExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1qTTVNalF6TlRFNUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1qVXlNakU0TnpnNUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1qWXlNelkyT0RRM0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
下面针对上面占位符变量进行修改,让其变量值来自于Fiscal Period(Single)输入值:
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE1qazFORGs1TXpBd0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE16STFPVFkzTnpjd0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE16VTRNekF6TkRneExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE16YzNOVEkwTXprMExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNE16a3pNVFE1TXpVeExtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
- 公式变量
用来替换公式中的某个值
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNU1UQXdNek16T0RBd0xtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)
![Query Designer:Variable 变量 Query Designer:Variable 变量](https://image.shishitao.com:8440/aHR0cHM6Ly9iYnNtYXguaWthZmFuLmNvbS9zdGF0aWMvTDNCeWIzaDVMMmgwZEhBdmFXMWhaMlZ6TG1OdWFYUmliRzluTG1OdmJTOWliRzluTHpjeE56WXhOQzh5TURFMU1ESXZNakl4TlRNNU1UUXdNek14TVRFeUxtcHdadz09LmpwZw%3D%3D.jpg?w=700&webp=1)