Re: Dynamically determine source measure in calculated field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Deepak,

I understand now how the Time Intelligence is supposed to work. Thanks
for that article by Mosha. It explains it much better than the SQL
Server help.

While this approach does help to simplify things, it still doesn't
address one of my main concerns. After talking the problem over with
another developer, I realize didn't really describe my initial question
that well. Basically, because it is possible for the user to select so
many different combinations of things on the reports, we have a ton of
logic in the reports, as well as a ton of calculated members in the
cube. Further, a good many of the reports are quite similar, (but
different enough to be a separate report), and as such, once this phase
of development is complete, these reports are going to be an absolute
nightmare to maintain because there is so much logic in the MDX queries
of each report (over 100 nested IIF statements). Obviously the MDX in
the reports can be completely parameterized, but is there any way to
take that parameterization to the cube level? That way, all the logic
would reside in the cube, making future maintenance much quicker and
easier. Also, if I was able to pass parameters all the way down to the
cube level, I could significantly reduce the number of calculated
members in the cube, further simplifying maintenance. Is this at all
possible?

Thanks,

Martin

.

Relevant Pages

  • Re: How Large Is Too Large?
    ... That said it is not INXS of column counts allowed and if ... single Fact table with 200 columns realistic and feasible? ... Reports or via a cube or cubes? ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Data mining tools
    ... down large amounts of aggregate data, then an OLAP cube is a good way ... number of, IMO, completely silly reports we were asked to create. ... I mostly use PivotCube because it's VCL for Delphi. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Novice - Help with OLAP Design
    ... Designing time dimensions ahead of time is probably the standard way ... query or cube processing costs. ... your comment about knowing what the reports need to look like ... metrics they want to know as well, whcih is apart from report layout ...
    (microsoft.public.sqlserver.olap)
  • OWC export to excel
    ... I am displaying cube data in pivot table reports using owc in ... sharepoint services. ... names from owc by going to commands and options and changing the ... in the cube and ignores changes applied in owc. ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS reports, Proclarity and MOSS 2007
    ... we talk about cube and dimension security in SSAS himself. ... if you have multiple reports created in proclarity and you want to display only the list of authorized reports, then you have to apply a security to the report himself, or through MOSS, you can apply different security for each page / web site / webpart created. ...
    (microsoft.public.sqlserver.datawarehouse)