Viewing 15 posts - 1 through 15 (of 26 total)
Not what I think. Instead of that I suggest you take a close look of the standaard Adventure Works cube, especially at the measuregroups Sales Targets and Sales Orders. ...
May 9, 2010 at 9:01 am
Hi Ron,
Thank for the sql scripts, i just executed them. Maybe you consider dtblCalendar to be the fact-table, but as I see it the facts should be based on [intJobNo]....
May 6, 2010 at 2:13 pm
ls,
No, the fact that the user has access via Excel means that the setup of permissions in Olap is correct. You probably have a permission issue in your OLAP client.
Cees
May 6, 2010 at 1:46 am
LS,
Try if the specified user can access the cube using Excel 2007 ? If so, your issue is a client issue, if not it's the setup of AS.
Cees
May 5, 2010 at 1:08 pm
Hi Wendy,
If something like what you posted is OK, then this you can solve this via the report wizard.
In the 'Design the Query' screen compose the query with all...
May 3, 2010 at 10:53 am
Hi Ron,
I'm not sure that I can help you out but I've something in my head which I think is worth a try. At least my idea is not dependent...
May 3, 2010 at 2:29 am
Hi Jason,
I don't know whether or not you've figured this out, but i think your MDX can and should do without the 'Existing'-piece. If your goal is to calculate the...
May 2, 2010 at 5:18 pm
Hello Ken.
If your intention is to query a cube then Mdx is your query-language. MDX has a built-in Median function you can use. The following (MDX) query results in the...
May 2, 2010 at 4:45 pm
Hello natarschia,
Indeed BackUp/Restore and Synchronization are alike, however Synchronization requires that the NT User account used in the Synchronization has (Analysis Services) administrative rights both to source and destination server....
May 2, 2010 at 3:04 am
Hello Najibullah,
You say you want to calculate the amount by month and year. I don't see any columns in your salary table with a reference to year and month....
May 2, 2010 at 2:36 am
Hi Steve,
Thanks for your additional remarks. You're right about the required additional step. At one of our Customers we do a simple (XMLA) scripted backup and restore (using a new...
April 29, 2010 at 8:15 am
LS,
One way to do this is:
1) Visual Studio: In your cube's datasource view (DSV) use named queries as dataproviders for the cube (measuregroups and dimensions). Where applicable include a where...
April 29, 2010 at 5:59 am
April 29, 2010 at 2:20 am
Hi Natarscha,
The script generated by the wizard has a section starting with Scope..., like this.
...
Scope(
{
...
April 29, 2010 at 2:11 am
Hi Paul,
Indeed, unless I misunderstand you, it is something pretty simple.
You can set the way your dimension attributes (like month in a time dimension) are ordered by uisng the attributes...
April 29, 2010 at 1:45 am
Viewing 15 posts - 1 through 15 (of 26 total)