Page 1 of 1
Build subset with SQL query?
Posted: Fri Jul 06, 2012 3:29 pm
by mmckimson
I really hate being a newbie, but if i don't ask I won't learn... Is it possible to build a subset of a dimension with a SQL query?
Here's my situation:
In one cube, we want to present sales data for only those products that have had history over the last two years, which would be a subset of a dimension I'll call dimProducts, which is a list of all active products. The dimProducts dimension in its entirety would be used in another cube. If we can create the subset via a query, mapping of the data in rules is simplified.
I've done some searching, but haven't found anything directly on point. Any help would be much appreciated.
Mike
Re: Build subset with SQL query?
Posted: Fri Jul 06, 2012 3:36 pm
by asutcliffe
mmckimson wrote:I really hate being a newbie, but if i don't ask I won't learn... Is it possible to build a subset of a dimension with a SQL query?
Here's my situation:
In one cube, we want to present sales data for only those products that have had history over the last two years, which would be a subset of a dimension I'll call dimProducts, which is a list of all active products. The dimProducts dimension in its entirety would be used in another cube. If we can create the subset via a query, mapping of the data in rules is simplified.
I've done some searching, but haven't found anything directly on point. Any help would be much appreciated.
Mike
You can create a TI process with a SQL query as a data source and have that create a subset. Is that what you mean?
Re: Build subset with SQL query?
Posted: Fri Jul 06, 2012 3:46 pm
by mmckimson
Exactly... I'll give that a try.
Re: Build subset with SQL query?
Posted: Fri Jul 06, 2012 4:52 pm
by mmckimson
In reviewing the current process that builds my dimension, we are updating the dimension elements, it's attributes and roll ups but I don't know how exactly I would tell it to take the query to save it as a subset on my Products dimension. This is probably easy, but I don't really know what to do. I assume there is probably something I do in the scripting, but I don't really know where to start.
Mike
Re: Build subset with SQL query?
Posted: Fri Jul 06, 2012 9:13 pm
by tomok
Here's what you can do. You can use the search function on this web site instead of asking to be spoon fed everything. There has to literally dozens of posts about building subsets via TI. You also need to think about reading the manuals AND taking a training class. Relying on the kindness of strangers is not a substitute for taking training. Eventually you are going to wear out your welcome.