Re: Dynamically determine source measure in calculated field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC 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)
  • Re: Recommended ref book for someone starting with Analytical Serv
    ... You would want to use he cube / olap technology in order to avoid building ... reports from scratch every time - by putting dimensions into cubes you get a ... fixed reports. ...
    (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)