markohrastovec
Programmer
I am trying to get some data out of the OLAP cube with MDX query and I don't know how.
I have information about products production costs in the cube. One of the dimensions is CostCenter (production line). That means some products are produced on one line some on another some on more. Measures are costs for each CostCenter. There are also other dimension like Account (energy, packaging,...), Time, Client, CostType (fix, variable),... but they are not relevant right now for the query I am interested in.
When I put CostCenter in columns and select one of the products I see on which lines that product produces expenses because I can see costs on those production lines.
Is it possible to get ther list of all other products which are also generating costs on the same lines as the selected product. In other words I get now the costs of the selected product for each costcenter. Instead of that I would like to get the set of products which are also produced on the same production lines.
This is only the first step in the problem I have. I need to get some complicated calculation out of the cube. I have tried to get some data from the cube and then calculate it in the program. It turns out that it is way to slow. I need to calculate as much as possible in the cube and get as little as possible lines and columns from OLAP cube because it takes quite a lot of time.
I have information about products production costs in the cube. One of the dimensions is CostCenter (production line). That means some products are produced on one line some on another some on more. Measures are costs for each CostCenter. There are also other dimension like Account (energy, packaging,...), Time, Client, CostType (fix, variable),... but they are not relevant right now for the query I am interested in.
When I put CostCenter in columns and select one of the products I see on which lines that product produces expenses because I can see costs on those production lines.
Is it possible to get ther list of all other products which are also generating costs on the same lines as the selected product. In other words I get now the costs of the selected product for each costcenter. Instead of that I would like to get the set of products which are also produced on the same production lines.
This is only the first step in the problem I have. I need to get some complicated calculation out of the cube. I have tried to get some data from the cube and then calculate it in the program. It turns out that it is way to slow. I need to calculate as much as possible in the cube and get as little as possible lines and columns from OLAP cube because it takes quite a lot of time.