| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | [BILLING_MINI_CUBE]: | | | Load *; | | | Select PseudoMDX ( | | | Dimensions ( | | | [0CACONT_ACC] (), | | | [0UCCONTRACT] (), | | | [0UCINSTALLA__0REGIO_GRP] (), | | | [ZBCMRVRS] (), | | | [ZBILLTYP] (), | | | [0CALMONTH] ()), | | | Measures ( | | | [2AI7MRP4Q13OTJXYIWDKDDGY4].[2ERNXFMBGSL13WB2Y7SM20R9O], //Net Amount | | | [2AI7MRP4Q13OTJXYIWDKDDGY4].[2CMXS3NQ3EUCYQ4IQK337P43W]), //Unit Billed | | | Variables ( | | | [0CMONTH] (I = [0CALMONTH].[$(vCurrentMonth)]), | | | [!V000002] (I = [0UCINSTALLA__0REGIO_GRP].[$(vCode)])), | | | From (BILLING_MINI_CUBE)); | | | Store * from [BILLING_MINI_CUBE] into [0UCSA_C05-ZQV_BILLING_CUBE_$(vCode).QVD]; | | | Drop table [BILLING_MINI_CUBE]; | | | |
| |
As it is very clear that there are 6 dimensions. For all dimensions and measures it gives "key" and "text". Is it possible to limit the result to text or key. I hope it will make my query faster as those are redundant.
Thanks in advance!
