pull-down menu based on user id

Hello,
When I lunch my report I want to display a pull-down menu
based on the user id. I know how to get userid but I do
not know how I can use it to display pull-down menu, for
some user id I should not display anything. Also if I
display the pull-down, after selection I should write
value selected to a table in SQL. How can I do that?
Thanks,
Jim.Throw the userid in the WHERE clause (assuming you are using a query
for the pull-down).
SELECT *
FROM tblPullDownMenu
WHERE userid = user.userid
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
> Hello,
> When I lunch my report I want to display a pull-down menu
> based on the user id. I know how to get userid but I do
> not know how I can use it to display pull-down menu, for
> some user id I should not display anything. Also if I
> display the pull-down, after selection I should write
> value selected to a table in SQL. How can I do that?
> Thanks,
> Jim.|||Minor clarification: This would have to be a query expression:
="SELECT * FROM tblPullDownMenu WHERE userid = " & User!UserID
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
> Throw the userid in the WHERE clause (assuming you are using a query
> for the pull-down).
> SELECT *
> FROM tblPullDownMenu
> WHERE userid = user.userid
>
> "JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
> > Hello,
> > When I lunch my report I want to display a pull-down menu
> > based on the user id. I know how to get userid but I do
> > not know how I can use it to display pull-down menu, for
> > some user id I should not display anything. Also if I
> > display the pull-down, after selection I should write
> > value selected to a table in SQL. How can I do that?
> > Thanks,
> > Jim.|||Thanks, Where should I use this SQL. Let's say, I am
running my report, at that time I need to check If this
string returns anything, if not display a pulldown menu,
accept user selection and update tblPullDownMenu.
How shoudl I do this? I am new at reporting.
>--Original Message--
>Minor clarification: This would have to be a query
expression:
>="SELECT * FROM tblPullDownMenu WHERE userid = " &
User!UserID
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
>news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
>> Throw the userid in the WHERE clause (assuming you are
using a query
>> for the pull-down).
>> SELECT *
>> FROM tblPullDownMenu
>> WHERE userid = user.userid
>>
>> "JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
>> > Hello,
>> > When I lunch my report I want to display a pull-down
menu
>> > based on the user id. I know how to get userid but I
do
>> > not know how I can use it to display pull-down menu,
for
>> > some user id I should not display anything. Also if I
>> > display the pull-down, after selection I should write
>> > value selected to a table in SQL. How can I do that?
>> > Thanks,
>> > Jim.
>
>.
>|||This should be typed into the Data pane of report designer.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:0da201c46e9a$31884690$a301280a@.phx.gbl...
> Thanks, Where should I use this SQL. Let's say, I am
> running my report, at that time I need to check If this
> string returns anything, if not display a pulldown menu,
> accept user selection and update tblPullDownMenu.
> How shoudl I do this? I am new at reporting.
>
> >--Original Message--
> >Minor clarification: This would have to be a query
> expression:
> >
> >="SELECT * FROM tblPullDownMenu WHERE userid = " &
> User!UserID
> >
> >--
> >Ravi Mumulla (Microsoft)
> >SQL Server Reporting Services
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
> >news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
> >> Throw the userid in the WHERE clause (assuming you are
> using a query
> >> for the pull-down).
> >>
> >> SELECT *
> >> FROM tblPullDownMenu
> >> WHERE userid = user.userid
> >>
> >>
> >> "JIM.H." <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
> >> > Hello,
> >> > When I lunch my report I want to display a pull-down
> menu
> >> > based on the user id. I know how to get userid but I
> do
> >> > not know how I can use it to display pull-down menu,
> for
> >> > some user id I should not display anything. Also if I
> >> > display the pull-down, after selection I should write
> >> > value selected to a table in SQL. How can I do that?
> >> > Thanks,
> >> > Jim.
> >
> >
> >.
> >|||Ravi, you know me, I need a little bit more help. LOL.
what should I do to make sure that the oulldown item
visaible and invisibale. I have more question below.
Thanks,
Jim.
>--Original Message--
>This should be typed into the Data pane of report
designer.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:0da201c46e9a$31884690$a301280a@.phx.gbl...
>> Thanks, Where should I use this SQL. Let's say, I am
>> running my report, at that time I need to check If this
>> string returns anything, if not display a pulldown menu,
>> accept user selection and update tblPullDownMenu.
>> How shoudl I do this? I am new at reporting.
>>
>> >--Original Message--
>> >Minor clarification: This would have to be a query
>> expression:
>> >
>> >="SELECT * FROM tblPullDownMenu WHERE userid = " &
>> User!UserID
>> >
>> >--
>> >Ravi Mumulla (Microsoft)
>> >SQL Server Reporting Services
>> >
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
>> >news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
>> >> Throw the userid in the WHERE clause (assuming you
are
>> using a query
>> >> for the pull-down).
>> >>
>> >> SELECT *
>> >> FROM tblPullDownMenu
>> >> WHERE userid = user.userid
>> >>
>> >>
>> >> "JIM.H." <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
>> >> > Hello,
>> >> > When I lunch my report I want to display a pull-
down
>> menu
>> >> > based on the user id. I know how to get userid but
I
>> do
>> >> > not know how I can use it to display pull-down
menu,
>> for
>> >> > some user id I should not display anything. Also
if I
>> >> > display the pull-down, after selection I should
write
>> >> > value selected to a table in SQL. How can I do
that?
>> >> > Thanks,
>> >> > Jim.
>> >
>> >
>> >.
>> >
>
>.
>|||Could you please describe what you're trying to do in more detail? By
pulldown menu, do you mean the report parameters dropdown?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:0d1901c46ea3$9d514490$a401280a@.phx.gbl...
> Ravi, you know me, I need a little bit more help. LOL.
> what should I do to make sure that the oulldown item
> visaible and invisibale. I have more question below.
> Thanks,
> Jim.
> >--Original Message--
> >This should be typed into the Data pane of report
> designer.
> >
> >--
> >Ravi Mumulla (Microsoft)
> >SQL Server Reporting Services
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:0da201c46e9a$31884690$a301280a@.phx.gbl...
> >> Thanks, Where should I use this SQL. Let's say, I am
> >> running my report, at that time I need to check If this
> >> string returns anything, if not display a pulldown menu,
> >> accept user selection and update tblPullDownMenu.
> >> How shoudl I do this? I am new at reporting.
> >>
> >>
> >> >--Original Message--
> >> >Minor clarification: This would have to be a query
> >> expression:
> >> >
> >> >="SELECT * FROM tblPullDownMenu WHERE userid = " &
> >> User!UserID
> >> >
> >> >--
> >> >Ravi Mumulla (Microsoft)
> >> >SQL Server Reporting Services
> >> >
> >> >This posting is provided "AS IS" with no warranties,
> and
> >> confers no rights.
> >> >"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
> >> >news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
> >> >> Throw the userid in the WHERE clause (assuming you
> are
> >> using a query
> >> >> for the pull-down).
> >> >>
> >> >> SELECT *
> >> >> FROM tblPullDownMenu
> >> >> WHERE userid = user.userid
> >> >>
> >> >>
> >> >> "JIM.H." <anonymous@.discussions.microsoft.com> wrote
> in
> >> message
> >> >news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
> >> >> > Hello,
> >> >> > When I lunch my report I want to display a pull-
> down
> >> menu
> >> >> > based on the user id. I know how to get userid but
> I
> >> do
> >> >> > not know how I can use it to display pull-down
> menu,
> >> for
> >> >> > some user id I should not display anything. Also
> if I
> >> >> > display the pull-down, after selection I should
> write
> >> >> > value selected to a table in SQL. How can I do
> that?
> >> >> > Thanks,
> >> >> > Jim.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hello,
I have a table:UserArea that has UserId and Area fields.
When the users run the report I want to check if the user
is available in UserArea table, if yes, I will display
the report by taking this area into consideration, if not,
I have another table: Areas, I should display this areas
to the user as a pull-down menu so that he can select one
area, after selection I should update UserArea table and
display report based on area again. So I am building
UserArea table while people are running report to give
results based on the area they are in.
Is this possible?
Jim.
>--Original Message--
>Could you please describe what you're trying to do in
more detail? By
>pulldown menu, do you mean the report parameters dropdown?
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:0d1901c46ea3$9d514490$a401280a@.phx.gbl...
>> Ravi, you know me, I need a little bit more help. LOL.
>> what should I do to make sure that the oulldown item
>> visaible and invisibale. I have more question below.
>> Thanks,
>> Jim.
>> >--Original Message--
>> >This should be typed into the Data pane of report
>> designer.
>> >
>> >--
>> >Ravi Mumulla (Microsoft)
>> >SQL Server Reporting Services
>> >
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:0da201c46e9a$31884690$a301280a@.phx.gbl...
>> >> Thanks, Where should I use this SQL. Let's say, I am
>> >> running my report, at that time I need to check If
this
>> >> string returns anything, if not display a pulldown
menu,
>> >> accept user selection and update tblPullDownMenu.
>> >> How shoudl I do this? I am new at reporting.
>> >>
>> >>
>> >> >--Original Message--
>> >> >Minor clarification: This would have to be a query
>> >> expression:
>> >> >
>> >> >="SELECT * FROM tblPullDownMenu WHERE userid = "
&
>> >> User!UserID
>> >> >
>> >> >--
>> >> >Ravi Mumulla (Microsoft)
>> >> >SQL Server Reporting Services
>> >> >
>> >> >This posting is provided "AS IS" with no warranties,
>> and
>> >> confers no rights.
>> >> >"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
>> >>
>news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
>> >> >> Throw the userid in the WHERE clause (assuming you
>> are
>> >> using a query
>> >> >> for the pull-down).
>> >> >>
>> >> >> SELECT *
>> >> >> FROM tblPullDownMenu
>> >> >> WHERE userid = user.userid
>> >> >>
>> >> >>
>> >> >> "JIM.H." <anonymous@.discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
>> >> >> > Hello,
>> >> >> > When I lunch my report I want to display a pull-
>> down
>> >> menu
>> >> >> > based on the user id. I know how to get userid
but
>> I
>> >> do
>> >> >> > not know how I can use it to display pull-down
>> menu,
>> >> for
>> >> >> > some user id I should not display anything. Also
>> if I
>> >> >> > display the pull-down, after selection I should
>> write
>> >> >> > value selected to a table in SQL. How can I do
>> that?
>> >> >> > Thanks,
>> >> >> > Jim.
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||Assuming you want to display data from table called Table_A, here's the
query I'd use in the data pane:
="select ta.* from Table_A ta, UserArea ua where ta.Area = ua.Area and
ua.UserID = " & User!UserID
On your second question, here's the approach I'd take:
1. Create a stored procedure that takes the userID as a parameter and checks
whether that userID is in the UserArea table. If is exists in that table,
don't return any rows. I it doesn't exist, return all Areas. Something like
follows:
drop proc sp_testuser
create proc sp_testuser (@.userIDParam varchar(32))
AS
BEGIN
select Area from testuser where not exists (select * from testuser where
userID = @.userIDParam)
END
2. Create a dataset based on the above stored procedure.
3. Create a query-based parameter list based on the dataset in previous step
(while in the Layout tab, go to Report menu item and choose Report
Parameters.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:172801c46f50$3bdc0bc0$a401280a@.phx.gbl...
> Hello,
> I have a table:UserArea that has UserId and Area fields.
> When the users run the report I want to check if the user
> is available in UserArea table, if yes, I will display
> the report by taking this area into consideration, if not,
> I have another table: Areas, I should display this areas
> to the user as a pull-down menu so that he can select one
> area, after selection I should update UserArea table and
> display report based on area again. So I am building
> UserArea table while people are running report to give
> results based on the area they are in.
> Is this possible?
> Jim.
> >--Original Message--
> >Could you please describe what you're trying to do in
> more detail? By
> >pulldown menu, do you mean the report parameters dropdown?
> >
> >--
> >Ravi Mumulla (Microsoft)
> >SQL Server Reporting Services
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:0d1901c46ea3$9d514490$a401280a@.phx.gbl...
> >> Ravi, you know me, I need a little bit more help. LOL.
> >> what should I do to make sure that the oulldown item
> >> visaible and invisibale. I have more question below.
> >> Thanks,
> >> Jim.
> >>
> >> >--Original Message--
> >> >This should be typed into the Data pane of report
> >> designer.
> >> >
> >> >--
> >> >Ravi Mumulla (Microsoft)
> >> >SQL Server Reporting Services
> >> >
> >> >This posting is provided "AS IS" with no warranties,
> and
> >> confers no rights.
> >> >"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >> >news:0da201c46e9a$31884690$a301280a@.phx.gbl...
> >> >> Thanks, Where should I use this SQL. Let's say, I am
> >> >> running my report, at that time I need to check If
> this
> >> >> string returns anything, if not display a pulldown
> menu,
> >> >> accept user selection and update tblPullDownMenu.
> >> >> How shoudl I do this? I am new at reporting.
> >> >>
> >> >>
> >> >> >--Original Message--
> >> >> >Minor clarification: This would have to be a query
> >> >> expression:
> >> >> >
> >> >> >="SELECT * FROM tblPullDownMenu WHERE userid = "
> &
> >> >> User!UserID
> >> >> >
> >> >> >--
> >> >> >Ravi Mumulla (Microsoft)
> >> >> >SQL Server Reporting Services
> >> >> >
> >> >> >This posting is provided "AS IS" with no warranties,
> >> and
> >> >> confers no rights.
> >> >> >"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
> >> >>
> >news:e876e3c8.0407201152.7951b8c5@.posting.google.com...
> >> >> >> Throw the userid in the WHERE clause (assuming you
> >> are
> >> >> using a query
> >> >> >> for the pull-down).
> >> >> >>
> >> >> >> SELECT *
> >> >> >> FROM tblPullDownMenu
> >> >> >> WHERE userid = user.userid
> >> >> >>
> >> >> >>
> >> >> >> "JIM.H." <anonymous@.discussions.microsoft.com>
> wrote
> >> in
> >> >> message
> >> >> >news:<08d201c46e65$5bc843e0$a601280a@.phx.gbl>...
> >> >> >> > Hello,
> >> >> >> > When I lunch my report I want to display a pull-
> >> down
> >> >> menu
> >> >> >> > based on the user id. I know how to get userid
> but
> >> I
> >> >> do
> >> >> >> > not know how I can use it to display pull-down
> >> menu,
> >> >> for
> >> >> >> > some user id I should not display anything. Also
> >> if I
> >> >> >> > display the pull-down, after selection I should
> >> write
> >> >> >> > value selected to a table in SQL. How can I do
> >> that?
> >> >> >> > Thanks,
> >> >> >> > Jim.
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Publishing OLAP based Pivotables from Excel

Hi

I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets.

I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables.

When I publish the Pivottable with Pivottable interactivity I get an error in the browser:

The query could not be processed

- An error was encountered in the transport layer

- The peer prematurely closed the connection

In the Pivottable I have set 'Save password' in properties.

Any suggestions ?

Thomas Black

I'm having the same error msg and problem to access SSAS 2005 cube over http at client machine.

This doesn't happen if you work in server (with Sql Server 2005 and web server installed).

|||Hello

did you manage to get around this error? I get this when I try to display a pivottable for data on a remote (but in LAN) server, connect goes through ...

Thanks for any help

Regards
Klaus Wiesel
|||

I used this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c&DisplayLang=en

That enables Pivottables and charts in Sharepoint. Very easy to use. Useful for designing dashboards.

Regard

Thomas

|||

I also encountered this problem ,need any solutions!

thanks a lot!

|||

Hello

I solved this for me.

The following is done by my app:

1) Connect to the server to access the existing AS databases and their cubes

2) make a connectionstring that is later on passed to the pivottable control (named opData here):

.opData.ConnectionString = sConnString
.opData.DataMember = .coCUBE_NAME
When building the sConnString you have to use a named user (in the format domain\username) with his password to be able to display the data of the remote machine

Regards

Klaus

Publishing OLAP based Pivotables from Excel

Hi

I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets.

I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables.

When I publish the Pivottable with Pivottable interactivity I get an error in the browser:

The query could not be processed

- An error was encountered in the transport layer

- The peer prematurely closed the connection

In the Pivottable I have set 'Save password' in properties.

Any suggestions ?

Thomas Black

I'm having the same error msg and problem to access SSAS 2005 cube over http at client machine.

This doesn't happen if you work in server (with Sql Server 2005 and web server installed).

|||Hello

did you manage to get around this error? I get this when I try to display a pivottable for data on a remote (but in LAN) server, connect goes through ...

Thanks for any help

Regards
Klaus Wiesel
|||

I used this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c&DisplayLang=en

That enables Pivottables and charts in Sharepoint. Very easy to use. Useful for designing dashboards.

Regard

Thomas

|||

I also encountered this problem ,need any solutions!

thanks a lot!

|||

Hello

I solved this for me.

The following is done by my app:

1) Connect to the server to access the existing AS databases and their cubes

2) make a connectionstring that is later on passed to the pivottable control (named opData here):

.opData.ConnectionString = sConnString
.opData.DataMember = .coCUBE_NAME
When building the sConnString you have to use a named user (in the format domain\username) with his password to be able to display the data of the remote machine

Regards

Klaus

Publication changes not appearing at subscriber?

I have setup a merge replication publication (SQL server 2005 wth SQL Mobile) with dynamic filters based on host name and when i sync to the pda all data appears fine. When I make changes on the PDA and synchronise, the changes are pushed back to the server fine.

However when I change data on the server and synchronise at the PDA, no changes ever appear!

Surely I must have missed something obvious or done something really stupid.

If i check the replication monitor it just says no changes so any suggestions would be great.

Thanks,

Andy

Ok, Ive managed to prove that if there is no @.subset_filterclause specified, it works fine. As soon as the filter is turned on i cannot add any new rows.

The filter is quite complex and as far as I can see, it will always fail because of the order in which records are added to the database. Can anybody clarify?

I have an organisation table and account management tables. The filter says download organisations that you are the account manager of. THerefore the organisation record is saved before the account management due to dependencies and at the point of creating the org, the trigger will fail because the account management record will not exist.

Surely this must be a standard problem so what am i doing wrong?

|||

After using one of our gold partner support calls, Microsoft have diagnosed the problem as my use of precomputed publications. This option in 2005 means that each insert fires a trigger which in turn evaluates the filter conditions.

In my case when i added a new organisation, it checked if the organisation was inside the users account management roles. This fails because the account management row has not yet been inserted (and cannot be added until after the org due to FK's.

The simple solution was to turn off precomputed partitions which sorted the problem.

Apparently it should be possible to use precomputed partitions if I define a row filter based on the last row to be inserted with all other rows linked through join filters. However, the suggested filters didnt work so I will try a bit more when i get an hour spare (in 2027 )

Publication changes not appearing at subscriber?

I have setup a merge replication publication (SQL server 2005 wth SQL Mobile) with dynamic filters based on host name and when i sync to the pda all data appears fine. When I make changes on the PDA and synchronise, the changes are pushed back to the server fine.

However when I change data on the server and synchronise at the PDA, no changes ever appear!

Surely I must have missed something obvious or done something really stupid.

If i check the replication monitor it just says no changes so any suggestions would be great.

Thanks,

Andy

Ok, Ive managed to prove that if there is no @.subset_filterclause specified, it works fine. As soon as the filter is turned on i cannot add any new rows.

The filter is quite complex and as far as I can see, it will always fail because of the order in which records are added to the database. Can anybody clarify?

I have an organisation table and account management tables. The filter says download organisations that you are the account manager of. THerefore the organisation record is saved before the account management due to dependencies and at the point of creating the org, the trigger will fail because the account management record will not exist.

Surely this must be a standard problem so what am i doing wrong?

|||

After using one of our gold partner support calls, Microsoft have diagnosed the problem as my use of precomputed publications. This option in 2005 means that each insert fires a trigger which in turn evaluates the filter conditions.

In my case when i added a new organisation, it checked if the organisation was inside the users account management roles. This fails because the account management row has not yet been inserted (and cannot be added until after the org due to FK's.

The simple solution was to turn off precomputed partitions which sorted the problem.

Apparently it should be possible to use precomputed partitions if I define a row filter based on the last row to be inserted with all other rows linked through join filters. However, the suggested filters didnt work so I will try a bit more when i get an hour spare (in 2027 )