Is there an easy way to nightly update a named set defined in the
cube?
Currently, I have a Named Set for "Today" defined in the cube. I use
this for Time Intelligence calculations and want to be able to change
the member each day. Is this feasible using XMLA or something along
those lines to be able to automate the process?
Re: Filtering out blank values from a cube ... data in the Cube browser/pivot table. ... set of rows but the output of the Bottom 5 would be different as there ... And use the same Named Set as a filter when I browse the ... (microsoft.public.sqlserver.olap)
Re: Filtering out blank values from a cube ... When I browse this cube I get blank values for combinations of Brand & ...Customer where there is no Qty shipped.... ... I was thinking of creating a Named Set where all the Brand/ ... And use the same Named Set as a filter when I browse the ... (microsoft.public.sqlserver.olap)
Re: 36 rolling month default ... i usually sort my dates in descending order in OLAP (sort on a ... that way you could make a named set based off of: ... > I've built a cube which allows users to view sales dollars ... > the oldest sales data on the database. ... (microsoft.public.sqlserver.olap)
Re: URGENT! Named Sets ... I find a way to get the named set with DSO and the Commands collection of ... the cube.... (microsoft.public.sqlserver.olap)
RE: Named sets in Analysis Manager different than WITH ... As far as I know Named Sets are evaluaed whenever a connection is made to the cube and therefore cannot be query-sensitive. ... > highest sales in the tuple that I am selecting. ... > I need to be able to create the named set for use in a 3rd party ... (microsoft.public.sqlserver.olap)
